Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a 'customised' matrix table that looks like this, able to display week, month, total columns that fall under FY21-Q4. However, I do not want to show the row where the Total is 0 or "-". Does anyone know how I can achieve it? Also, I'm not sure why there is an empty 3rd row showing in my table, I'd like to remove that row as well.
I have attached the sample pbix here: https://www.dropbox.com/s/wn99p8m6c4q1xrw/test1.pbix?dl=0
Regards,
BK
Solved! Go to Solution.
Hi @Anonymous
1. Create this measure
ShowMeasure =
VAR aux_ = CALCULATE([ActlPlan_Rev_Range], ALL(_ParaPeriod[Para Period]))
RETURN
IF(aux_<>0, 1, 0)
2. Use the measure as visual filter, seelcting to show when value is 1
See it all at work in the attached file.
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hi @Anonymous
1. Create this measure
ShowMeasure =
VAR aux_ = CALCULATE([ActlPlan_Rev_Range], ALL(_ParaPeriod[Para Period]))
RETURN
IF(aux_<>0, 1, 0)
2. Use the measure as visual filter, seelcting to show when value is 1
See it all at work in the attached file.
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |