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
Hi all,
I search this topic in web but i couldn't get enough information about that.
I have a matrix table with 6 measures. it changes by category.
My matrix table looks like that
Category M1 M2 M3 M4 M5 M6
3001 12 5 3 9
3002 19 7 2 6
3007 5 9 1 5
The M5 and M6 columns change by value, Sometimes they don't have value, sometimes have value. I want to hide theese columns when they don't have value. I want to hide them completely. Their headers shouldn't be view.
Is it possible or not ?
Thanks
Solved! Go to Solution.
@Anonymous,
Add a seperate table that contains column names in one column, then drag the column to Columns, measure below to Values.
Measure = SWITCH ( SELECTEDVALUE ( Table2[Column1] ), "M1", [M1], "M2", [M2] )
@Anonymous,
Add a seperate table that contains column names in one column, then drag the column to Columns, measure below to Values.
Measure = SWITCH ( SELECTEDVALUE ( Table2[Column1] ), "M1", [M1], "M2", [M2] )
@Anonymous Please make sure that you have unchecked the "Show Items with no data" option (under columns)
Proud to be a PBI Community Champion
@PattemManohar there aren't a selection like "Show Items with no data" on my case. By the way in rows option there is a seleciton like that but in values, not.
@Anonymous You need to do that option setting for "Column" fields not for Values fields. Refer below:
Proud to be a PBI Community Champion
Values which i use in values entry section, are calculation. I can't use them on columns. Is there another solution for this ?
Proud to be a PBI Community Champion
I can't send the data screenshot, what do you want to know about data, i can tell you
Values are measure.
Category and Category2 are Column.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
95 | |
80 | |
62 | |
56 |
User | Count |
---|---|
252 | |
121 | |
112 | |
81 | |
70 |