Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
In Power BI - have a matrix with Rows- Category and Columns with Fiscal week numbers and Values with Sales units. I have to hide/surpass the fiscal week number columns with the values zero in sales units.
Please see the below snip for reference
Is it possible to hide these columns?, for example - week 05, week 06.....
Thanks in advance
very clever
You can write your mesure so 0 is returned as BLANK which will leave it out of the matrix if all values in the column are blank. We do this using a trick of multiplying a number by BLANK returns BLANK and DIVIDE by 0 returns BLANK.
The first table has just a SUM measure.
Total Amount = SUM ( 'Table'[Amount] )
The second table has the measure to return BLANK for 0
Total Amount no 0 =
VAR _Amount = SUM ( 'Table'[Amount] )
RETURN _Amount * DIVIDE (_Amount, _Amount)
You can see WEEK2 and WEEK3 are not showing in the second matrix.
I tried this and my column is giving blank values but it hasn't gone off from the report. Is there anything more that you did? Like, chnaged some settings or something?
Would be great if you could add the pbix file as an attachment.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |