Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
i am trying to create a risk heatmap using the matrix visualization but need it to show all the columns and rows even if the data has been filtered by the viewer such that there is no data for one of the columns or rows. i.e. the matrix should always be 5x5 even if its filtered down to a site with data in say only 4 rows. I've tried toggling "show items with no data" but this doesn't seem to change the outcome. any ideas?
Hi @sataylor,
In this scenario, my first thread is to create a dynamica column value using measure according to slicer selection. For example, if we don't select "High", then, all the data values corresponding to "High" will be set to Blank, others keep original values. But a measure returns one scalar value each time, and it show data dynamically according to context. So, it is not allowed to specify a special value for those rows where [Probability] equals "High".
Another thing you should know is that Blank will not be displayed in visual. The entire row in which [Probability] equals "High" will be hidded. In order to show this row, we have to set " " (space) for data values, but this will change the data type to text automatically.
In conclusion, this requirement cannot be achieved right now.
Best regards,
Yuliana Gu
There's 2 things. One is to show rows that are not filtered but have no data. That is the setting you have referred to. But you seem to be saying something different. How do you see it working? It sounds like you are saying you want the user to filter, but to still show the rows. That can happen provided the filter doesn't actually filter the row in question. E.g. The filter means the rows are empty but not removed. So I guess it depends on the data model you have.
I am showing risks across a number of sites so what i would like to have is a matrix that stays at a fixed size (ie 4 rows and 5 columns)regardless of the data being plotted. when i plot all my data, like in the first clip below there is at least 1 data point in each row and column so they are all visible but if it sliced to a subset of the data some rows or columns don't have any data so are not shown, like in the second clip but i would like to show those on the same 4x5 matrix as the total dataset
How about writing a measure that returns zero (instead of blank) in the case there is no value to return? I think this will do what you want.
Sounds like you might need to create a calucated measure that you should use in the Values area of the dropdown, and make sure it always returns a 0 rather than a blank()
Hi Phil,
Is there a way to hide or collapse blank columns in a matrix visual? Thanks!
Best regards,
Ferdinand
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |