# Show columns even if there are no issues to display

**URL:** <https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213>\
**Category:** Questions & Answers\
**Tags:** calculatedmembers\
**Created:** [December 8, 2022, 7:41am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213 "2022-12-08T07:41:08Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![MZH](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b9bd4f/32.png) [@MZH](https://community.eazybi.com/u/MZH)\
**Post date:** [December 8, 2022, 7:41am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/1 "2022-12-08T07:41:08Z")

</div>

Hi,  
I try to create a risk matrix in eazyBI. It should show all columns and rows at any time, no matter if there are risks in the respective cell or not.  
I’ve managed to get the rows and columns in the right order using calculated members:

```auto
sorted Risk Probability = Aggregate({
[Risk Probability].[Risk Probability].[very high],
[Risk Probability].[Risk Probability].[high],
[Risk Probability].[Risk Probability].[low],
[Risk Probability].[Risk Probability].[very low]
})

```

and

```auto
sorted Risk Impact = Aggregate({
[Risk Impact].[Risk Impact].[very high (opportunity)],
[Risk Impact].[Risk Impact].[high (opportunity)],
[Risk Impact].[Risk Impact].[low (opportunity)],
[Risk Impact].[Risk Impact].[very low (opportunity)],
[Risk Impact].[Risk Impact].[very low (risk)],
[Risk Impact].[Risk Impact].[low (risk)],
[Risk Impact].[Risk Impact].[high (risk)],
[Risk Impact].[Risk Impact].[very high (risk)]
})

```

But, for example, if there is no risk with Impact “high”, the column “high (risk)” is not shown. How can i get eazyBI to show all columns and all rows at any time. If there is no issue for the cell “0” should be displayed.  
I’ve tried a measure with the following code, but it just converted the empty cells to 0 for the rows and columns that were already shown.

```auto
CoalesceEmpty([Measures].[Issues created],0)
![risk_matrix|690x242](upload://7ACogXzQAWf8FpRmqMlijmIxHq4.jpeg)

```

Thanks for your help and best regards  
Martin

 ![risk_matrix](https://community.eazybi.com/uploads/default/original/2X/3/3532ea5292bf3648bc0dd161d77556e16ea00eb4.jpeg)

---

<div class="post-metadata">

**Author:** ![MZH](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b9bd4f/32.png) [@MZH](https://community.eazybi.com/u/MZH)\
**Post date:** [December 14, 2022, 6:43am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/2 "2022-12-14T06:43:20Z")

</div>

Hi,  
any ideas on this questions? I would be happy for any hint.

Thanks

---

<div class="post-metadata">

**Author:** ![Erik1](https://community.eazybi.com/user_avatar/community.eazybi.com/erik1/32/2576_2.png) [@Erik1](https://community.eazybi.com/u/Erik1)\
**Post date:** [December 15, 2022, 11:58am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/3 "2022-12-15T11:58:27Z")

</div>

Hi,  
Try changing these two settings.

 ![image](https://community.eazybi.com/uploads/default/original/2X/5/5cd89462a51755f228377d4872ad4432321bcf57.png)

---

<div class="post-metadata">

**Author:** ![Elita.Kalane](https://community.eazybi.com/user_avatar/community.eazybi.com/elita.kalane/32/14957_2.png) [@Elita.Kalane](https://community.eazybi.com/u/Elita.Kalane)\
**Post date:** [December 16, 2022, 12:56pm UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/4 "2022-12-16T12:56:18Z")

</div>

Hello @MZH

@Erik1 suggestion might indeed help (thank you, @Erik1!). If your “hide empty” option is enabled, that might be the reason you do not see any data. If this still doesn’t help, please make sure that:

- You have imported all custom members into the eazyBI report
- The name of all members is written correctly in your aggregate function (I suggest using [autocomplete](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Functionandmemberlibrary) list)

Kind regards,

Elita from [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![MZH](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b9bd4f/32.png) [@MZH](https://community.eazybi.com/u/MZH)\
**Post date:** [December 19, 2022, 6:48am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/5 "2022-12-19T06:48:15Z")

</div>

Hi,  
thanks for your tipps.  
The settings “Nonempty” and “Hide empty columns” were already set correctly.  
I think the problem is, that there is not a single issue in the data with probability=high and impact=low (opportunity).

I’ve found a workaround to define seperate calculated member for every status and add them manually to the report, but i don’t think that is the best solution.

 ![risk_matrix_with_calculated_members](https://community.eazybi.com/uploads/default/original/2X/3/34b5bc1cdd9f65e6c36748a3d25fbbe8e214ceb8.png)

---

<div class="post-metadata">

**Author:** ![Jed1003](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/839c29/32.png) [@Jed1003](https://community.eazybi.com/u/Jed1003)\
**Post date:** [June 14, 2023, 9:34am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/6 "2023-06-14T09:34:13Z")

</div>

Hi @MZH

Did you ever get a resolution for this? if you did please could you share or alternativly share the calculated measure code example for one of the individual risk levels?

Thanks in advance,

Jed

---

<div class="post-metadata">

**Author:** ![MZH](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b9bd4f/32.png) [@MZH](https://community.eazybi.com/u/MZH)\
**Post date:** [June 14, 2023, 9:51am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/7 "2023-06-14T09:51:35Z")

</div>

Hi @Jed1003 ,  
unfortunately there was no other solution.  
Attached you find a screenshot for one of my calculated **members**. Hope it helps.  
Please be aware, that you cannot name the calculated member exactly like the field value. That’s why I chose to use the underscores.

 ![image](https://community.eazybi.com/uploads/default/original/2X/f/f02c77746e7c1f6e4d491d0f70a13ad2a4cc8751.png)

Best regards,  
Martin

---

<div class="post-metadata">

**Author:** ![Jed1003](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/839c29/32.png) [@Jed1003](https://community.eazybi.com/u/Jed1003)\
**Post date:** [June 14, 2023, 10:08am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/8 "2023-06-14T10:08:56Z")

</div>

Thanks @MZH . You would have thought EazyBi could do this considering Risk Matrix is a fundamental report. Many thanks for getting back to me so quickly

---

<div class="post-metadata">

**Author:** ![Jed1003](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/839c29/32.png) [@Jed1003](https://community.eazybi.com/u/Jed1003)\
**Post date:** [June 14, 2023, 11:18am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/9 "2023-06-14T11:18:22Z")

</div>

Hi @MZH - Last question i promise! How did you get the formatting? I’ve tried the conditional formatting but obvioulsy does not work with “Range” as there may be many cells in a specific row or column with the same number. Could you share how you managed this please. Thanks again! 🙂

---

<div class="post-metadata">

**Author:** ![MZH](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b9bd4f/32.png) [@MZH](https://community.eazybi.com/u/MZH)\
**Post date:** [June 14, 2023, 3:32pm UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/10 "2023-06-14T15:32:42Z")

</div>

Hi @Jed1003,  
sure, no worries.  
The conditional formatting is done with a custom formula.  
You need to define the values and colours.

After that I used CASE statements to identify each cell and define the corresponding value.

 ![image](https://community.eazybi.com/uploads/default/original/2X/d/d235b4c3d5820578053c78a53dbe9ea2bfabadb2.png)

Honestly: I don’t know if there might be a more efficient way 😉

Best regards  
Martin

```auto
CASE [Risk Probability].CurrentHierarchyMember.Name
WHEN "_100%" THEN 
	CASE [Risk Impact].CurrentHierarchyMember.Name
	WHEN "greatO" THEN "dark green"
	WHEN "majorO" THEN "dark green"
	WHEN "moderateO" THEN "medium green"
	WHEN "minorO" THEN "medium green"
	WHEN "minorT" THEN "red"
	WHEN "moderateT" THEN "red"
	WHEN "majorT" THEN "dark red"
	WHEN "severeT" THEN "dark red"
	END
WHEN "_very likely" THEN 
	CASE [Risk Impact].CurrentHierarchyMember.Name
	WHEN "greatO" THEN "dark green"
	WHEN "majorO" THEN "medium green"
	WHEN "moderateO" THEN "medium green"
	WHEN "minorO" THEN "green"
	WHEN "minorT" THEN "orange"
	WHEN "moderateT" THEN "red"
	WHEN "majorT" THEN "red"
	WHEN "severeT" THEN "dark red"
	END
WHEN "_likely" THEN 
	CASE [Risk Impact].CurrentHierarchyMember.Name
	WHEN "greatO" THEN "medium green"
	WHEN "majorO" THEN "medium green"
	WHEN "moderateO" THEN "green"
	WHEN "minorO" THEN "green"
	WHEN "minorT" THEN "orange"
	WHEN "moderateT" THEN "orange"
	WHEN "majorT" THEN "red"
	WHEN "severeT" THEN "red"
	END
WHEN "_unlikely" THEN 
	CASE [Risk Impact].CurrentHierarchyMember.Name
	WHEN "greatO" THEN "green"
	WHEN "majorO" THEN "green"
	WHEN "moderateO" THEN "light green"
	WHEN "minorO" THEN "light green"
	WHEN "minorT" THEN "yellow"
	WHEN "moderateT" THEN "yellow"
	WHEN "majorT" THEN "orange"
	WHEN "severeT" THEN "orange"
	END
WHEN "_very unlikely" THEN 
	CASE [Risk Impact].CurrentHierarchyMember.Name
	WHEN "greatO" THEN "green"
	WHEN "majorO" THEN "light green"
	WHEN "moderateO" THEN "light green"
	WHEN "minorO" THEN "light green"
	WHEN "minorT" THEN "yellow"
	WHEN "moderateT" THEN "yellow"
	WHEN "majorT" THEN "yellow"
	WHEN "severeT" THEN "orange"
	END
END

```

---

<div class="post-metadata">

**Author:** ![Jed1003](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/839c29/32.png) [@Jed1003](https://community.eazybi.com/u/Jed1003)\
**Post date:** [June 14, 2023, 7:34pm UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/11 "2023-06-14T19:34:19Z")

</div>

Legend. Working great here!

---

<div class="post-metadata">

**Author:** ![MZH](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/b9bd4f/32.png) [@MZH](https://community.eazybi.com/u/MZH)\
**Post date:** [June 15, 2023, 9:15am UTC](https://community.eazybi.com/t/show-columns-even-if-there-are-no-issues-to-display/11213/12 "2023-06-15T09:15:59Z")

</div>

Hi @Jed1003,  
Great, happy to help.  
Please share your solutions and ideas with the community as well where possible.

Thank you very much and best regards,  
Martin