Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have created a matrix where we are replacing all the Blank values with "*". I have created a DAX calculation, which is working fine. Field used in below Matrix are :
Rows : City Name
Columns : Calendar Quarter
Values : Number of Orders Cancelled
Now the issue if , if we have all blanks in that quarter, we want to hide that quarter in the Matrix.
Please advise how can we resolve this.
Thanks.
Hi @Anonymous ,
There is no such an visibility option that supports to conditionally hide/show column in Matrix. One option is to hide or show the values in the column by creating measures, but column headers are still appeared even there is no data. Reference: https://community.powerbi.com/t5/Desktop/How-can-i-hide-Column/td-p/110087
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |