The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
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