Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Remove from here
But be visible for all IDs under the icon once plus icon is clicked
Hi @WTAS80486 ,
As a workaround, you can turn off "Stepped layout" and turn on "+/- icons" under Row headers pane for a Matrix visual.
If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hello:
Is this what you are asking? The columns don't show until drilled down into. Stepped layout is on. I hope this helps~!
I want to remove description at highest level but keep at lower levels
Remove here, this FC-C-1120 is a text column(Description)not measure
But display it only after clicking + icon
In INSCOPE function
if(isinscope(Table[Level 2]), [Measure], Blank())
How can i use column instead of measure since mine is description column
@WTAS80486 , you can make it blank using isinsope
if(isinscope(Table[Level 2]), [Measure], Blank())
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
IsInScope - Switch data at different levels: https://youtu.be/kh0gezKICEM
@amitchandak It is working for measure but what if I have to return a column text (Description)at drill down level
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
23 | |
21 | |
20 | |
14 | |
12 |
User | Count |
---|---|
43 | |
31 | |
25 | |
22 | |
22 |