The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear team,
I would like to design a grid report, which should display the second level of details while selecting only one primary level data in the slicer. If I selected multiple options in the primary level slicer then the grid should display the selected primary level data. Is it possible to achieve this on a Power BI desktop?
I have a single table with a proper hierarchy level as well. I have tried the DAX function using IF() but the true/false section table attribute is not displayed for the suggestion. it is a text data type. Any Idea that will be helpful to achieve this design?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @vignesvar ,
I made some modifications to your original expression and the result is as follows:
Hope it helps!
Best regards,
Community Support Team_ Scott Chang