Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can somebody help me with this?
How do I make a matrix show 0s instead of blank?
I tried
but it doesn't work
Solved! Go to Solution.
@sj_ - The problem is that all of the rows/columns come from the same table. There simply is no intersection of those attributes (they are filtered out of the result set). One way to fix this is by creating a Dimensional Model, where a fact table is related to dimension tables. Dimensional models are ideal in Power BI. For this particular case, your visual would behave as desired if you do the following:
1. Create a new Calculated Table:
Entity = DISTINCT(controls[Entity])
2. Replace Entity in the Matrix with Entity from the new Entity table.
Cheers,
Nathan
https://drive.google.com/file/d/1Vnoe0MzD7AKlqmLA_Ioyl4wkDzP7jWRb/view?usp=sharing
here is the pbix file. Please let me know if you cannot open the file. and thank you for your help!
Have you tried ISFILTERED or HASONEVALUE?
Hi! Could you elaborate on this?
ISFILTERED or HASONEVALUE takes an existing column as a parameter. What columns would you use to make 0s appear?
@sj_ - The problem is that all of the rows/columns come from the same table. There simply is no intersection of those attributes (they are filtered out of the result set). One way to fix this is by creating a Dimensional Model, where a fact table is related to dimension tables. Dimensional models are ideal in Power BI. For this particular case, your visual would behave as desired if you do the following:
1. Create a new Calculated Table:
Entity = DISTINCT(controls[Entity])
2. Replace Entity in the Matrix with Entity from the new Entity table.
Cheers,
Nathan
My real file is connected to a sql database, so unfortunately I cannot create a calculated table for this.
But, it makes sense to me why it is happening. Thank you so much for your help!
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |