Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi!
I need to create a visualization where i could choose to show sales by different different levels in the organization. Dim Organize have the structure as the example below and then i have a fact table structured as below. I need to create a report that looks like the report example below. Is it possible to do this in dax maybe with the switch or something and how to solve that in dax?
Br Arne
@Arne Who decides what level name should be shown in the last visual? Have you considered using hierarchies, and the +/- feature of the matrix rows?