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
Hi,
I have the following issues.
I have a matrix table where i have categories in Rows and MonthName in Columns.
In values i have multiple dax measures.
in the format section i have toggled to the right the " Switch values to rows so to have the measures displayed just right on the categories. i need somehow to make non related measures to categories not visible. So in the first category for example to have only the first 3 measures displayed, in the second category the other 3 etc...
Categories is a dim table that is connected with the fact table with the corresponding column.
i have tried to adjust the measure like this with no success:
thank you a lot
Hello ,
Anyone who can help me on that? 🙂
thank you
Hi @Harrisfil
Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.
Hello Rita,
Thanks for your answer. Sure here you are
I have attached also an excel file with the desired result.
Thanks again
Harris
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 |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
125 | |
108 | |
60 | |
55 |