Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to remove the Blank at DM & MC level (Marked in red) with out impacting DO level in Hierarchy slicer. Because, there is some calculation based on that. Is there any possible ways? I tried removing the blank from filter. but, it is impacting the DO level as well. If I removing the null values / blank in DM & MC, the region is also getting vanished. Please help!!!!
Solved! Go to Solution.
Hi @Anonymous ,
The default hierarchy silcer can't remove blank values. You could use the custom visual of hierarchyslicer to have a try.
Reference: Solved: Remove blank from hierarchy slicer - Microsoft Power BI Community
Please note that it will both remove the blank values and non-blank value under it.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous One way would be to create three new columns and use those in your hierarchy.
Level 1 = [Region]
Level 2 = IF(ISBLANK([DM]) && ISBLANK([MC]),[DO],[DM])
Level 3 = [MC]
This is not coming as expected. 😥
@Anonymous Not sure what is not expected/problem. Attached a PBIX below signature if perhaps it helps.
@Greg_Deckler is there any way to remove the null / blank from level 3 as well. because when I am trying to remove it. many items are also getting lost.
Hi @Anonymous ,
The default hierarchy silcer can't remove blank values. You could use the custom visual of hierarchyslicer to have a try.
Reference: Solved: Remove blank from hierarchy slicer - Microsoft Power BI Community
Please note that it will both remove the blank values and non-blank value under it.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Greg_Deckler Thanks for your quick solution. Will try to work with this turn around. however, a blank / null is coming in Level 3 level (Marked below). Our requirement is also to remove that as well.
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |