Solved: Matrix visualization preview

DerMoe · ‎04-06-2021

Hi guys,

I have a quick question about the matrix visualization:

Is there a way to display the values only after the rows are fully expanded?

The date shown in the first image does not make sense in this context, not until the lines are completely unfolded.

Greetings

amitchandak · ‎04-06-2021

@DerMoe , You can hide subtotal using isinscope. This means there will be no values on subtotal

refer

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎04-06-2021

@DerMoe , You can hide subtotal using isinscope. This means there will be no values on subtotal

refer

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Matrix visualization preview

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

How to Get Your Question Answered Quickly

Be one of the first to start using Fabric Databases.