hi all,
I have a column called "Production only at assembly level" in the Matrix visual. I want this column to only show values when I am at the top most level of the heirarchy. Can we hide the values at the low levels and only show at higher levels selectively. Please refer to attached screenshots for details
Current condition -
Expected Result -
Thanks for helping 🙂
Solved! Go to Solution.
@rohit1410 , I think ininscope can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
@rohit1410 , I think ininscope can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
The link provided was spot on.
And the combination of Inscope and switch function did the trick.
Thanks a lot.😀
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
222 | |
57 | |
48 | |
44 | |
43 |
User | Count |
---|---|
289 | |
209 | |
79 | |
75 | |
66 |