Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Good Afternoon,
I have created a matrix using two measures and a slicer, when one of the measures is <blank> I would like to hide just this row leaving the other measure visable, is this possible?
Example without blanks:
Count 6
Average 3
Example with Blanks:
Count 6
Average
What I would like to see, when there is a blank:
Count 6
Hoepfullythis makes sense?
Solved! Go to Solution.
hi, @Anonymous
To my knowledge, I'm pretty sure there isn't an elegant way to do this at this time.
Here are some related ideas you can vote and comment on to add your support to encourage Microsoft to fix this limitation:
Show/Hide columns in report based on expression.
and here is a workaround that you may refer to:
Create a separate dim table just with measure name as below:
Then create another measure:
Measure = IF(SELECTEDVALUE('Table'[Type])="Average",[Average] ,IF(SELECTEDVALUE('Table'[Type])="Count",[Count]))
Now drag the field Type from this new table and this new measure into a visual.
and here is sample pbix file, please try it.
Best Regards,
Lin
i have calculated the location wise fillrate(measure in %) with customers i am comparing two customers fillrate and i need to remove the empty row.we have only single measure here that is fillrate
location periods(8*1,8*2,8*3) total
india 20%,30%,_ 50%
USA _,_,_ _
how would we remove the entire row
hi, @Anonymous
To my knowledge, I'm pretty sure there isn't an elegant way to do this at this time.
Here are some related ideas you can vote and comment on to add your support to encourage Microsoft to fix this limitation:
Show/Hide columns in report based on expression.
and here is a workaround that you may refer to:
Create a separate dim table just with measure name as below:
Then create another measure:
Measure = IF(SELECTEDVALUE('Table'[Type])="Average",[Average] ,IF(SELECTEDVALUE('Table'[Type])="Count",[Count]))
Now drag the field Type from this new table and this new measure into a visual.
and here is sample pbix file, please try it.
Best Regards,
Lin
Try using the Filters pane to select the measure in questions and apply a filter of 'is not blank'.
This filters the complete matrix, not just the row that I am interested in so I end up with no rows at all
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
106 | |
64 | |
60 |