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.
I have a matrix report as below ( rows : group, columns : hours and value : measure field( count of rows)). The column hours are missing if i have blank value. I verified right click on Hours ( Show items with no data is checked). Still i am not able to see the blank data for the column.
Solved! Go to Solution.
Resolved as below:
Created a new table with distinct column
Add relationship to the tables
created matrix table
Hi @sanjay009 - This blank seems missing from the dataset because 'Blank' is not a tangiable value. You can try below 2 ways:
1.) If this is coming from SQL table/View Try Something like
SELECT ISNULL(myColumn, 0 ) FROM myTable
2.) Create a new Measure and Add 0 to the value, Something like:
myColumn +0
And use this new Measure in your matrix visual.
Hope either of this will be helpful
Cheers,
-Namish B
I applied the measure no change to the columns and values. I still don;t see the blank values
Resolved as below:
Created a new table with distinct column
Add relationship to the tables
created matrix table
Did you try adding "+0" to your countrows measure?
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |