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.
I had many blanks values in the matrix hierarchy due to asymmetrical hierarchy levels. I managed to hide them with this metric :
Remove Blanks = SWITCH(TRUE(), AND(ISINSCOPE(hier[Level 2]),ISBLANK(VALUES(hier[Level 2]))),BLANK(), AND(ISINSCOPE(hier[Level 3]),ISBLANK(VALUES(hier[Level 3]))),BLANK(), AND(ISINSCOPE(hier[Level 4]),ISBLANK(VALUES(hier[Level 4]))),BLANK(), SUM[value])
But (+) icons are still visible where the hidden blank values are. I want for the (+/-) icon to hide in all places where the last value in the hierarchy is reached, so where the blanks are hidden (or at least (-) icon instead of (+) icon to show). Is there any way to change (+/- ) icon behavior, or other solution to my problem, so that (+/-) icon works as I need to?
On the screen above, the marked row is the last in the hierarchy for his parent row (next one was blank and is hidden now with metric), but there still is a (+) icon.
Was there any result with supressing + icons when the last point in the heirarchy is reached? I have three heirarchies in a matrix, but the third heirarchy only applies to one catgegory but the user is allowed to expand all categories to the third heirarchy which is pointless. Is there a measure I can use to tell the matrix not to show the expand icons when the heirarchy is not relevant?
Hi @Anonymou5,
AFAIK, power bi will auto-hide the row if all column fields do not contain corresponding records.
BTW, SWITCH function not suitable to compare with summarised values, if multiple conditions matches, it always returns the first condition they match. So I think your formula does not work for your records, can you please share a pbix file for test?
In addition, it seems like your formulas also expand these 'hidden' rows. I'd like to suggest you add filters in your calculations formulas to ignore the calculation on the above rows to prevent the fill down '0.0' results on specific rows.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |