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 guys!
There is a data model, which I represent in Matrix visualisation, it contains multiple-level rows and columns values, see Pic 1:
I defined some measures - A/B simple one, but I need to show it under [Version] = "ACT" only, so I put a condition contains "Filter" function into it, here u can see it on Pic 2:
Measures appear in every single [Version], but only "ACT" contains not blank values. Its almost there, but my ideal state is on Pic 3:
I need to suppress empty items, because calculated measures have to be under "ACT" [Version] only, other [Versions] have to contain "Value" only.
I used this definition in Excels Power Pivot and it works the way I want, but PBIs behaviour is different.
Could you please suggest me, how can I reach my ideal state?
Thanks in advance! 😄
Solved! Go to Solution.
Hi @xkoby001 ,
I'm afraid that there is no elegant way to implement it. Anyway, you can use the following method as a workaround...
Power BI > Hide NULL or BLANK values in Matrix visual
1. Toggle off the Word wrap option under the Column headers tab
2. Adjust the size of the Values field(s) with all blank values (for example: vs_BG%) you need to hide small enough to be invisible manually
And you can share some sample data and your expected result with backend logic and special examples. It is better if you can provide a simplified pbix file. Later we can provide you a suitable solution base on your provided info. Thank you.
Best Regards
Hi @xkoby001
In thr filter pane adjust the settings for the ACT measure as Not Is Blank. I don't have a clear idea about the complicity of your report therefore you might need to lock the filter of some othe measure using the lock icon at the corner of each measure in the filter pane
Hi @tamerj1 !
Thank you for reaction, but unfortunatelly it distorts reality (if ACT is blank, but BG is not).
Thank you! 🙂
@xkoby001 , Based on what I got
You need if (isblank([Your measure]), [New measure],[Measure])
Hi @amitchandak ! Thank you for reaction!
Could you please give me more details, should I define a new one measure, which will combine my current measures?
...
Because two fields [PeriodAnalysis] and [Version] are text fields, they are in Column part of matrix.
[Value] in Values part of matrix contains fact values, [vs_XX%] are calculated measures.
Hi @xkoby001 ,
I'm afraid that there is no elegant way to implement it. Anyway, you can use the following method as a workaround...
Power BI > Hide NULL or BLANK values in Matrix visual
1. Toggle off the Word wrap option under the Column headers tab
2. Adjust the size of the Values field(s) with all blank values (for example: vs_BG%) you need to hide small enough to be invisible manually
And you can share some sample data and your expected result with backend logic and special examples. It is better if you can provide a simplified pbix file. Later we can provide you a suitable solution base on your provided info. Thank you.
Best Regards
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |