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,
I would like to create a simple measure from table 1, Column 2 where the result should be a count of Green, Blue and Blanks. When working with visuals it does not include the blank cells.
Table 1
Column 1 Column 2
Case 1 Green
Case 2 Blue
Case 3
Case 4 Green
Case 5 Blue
Case 6
Case 7 Green
Case 8 Blue
Result:
Green = 3
Blue = 3
Blank = 2
Any idea how I could display the blanks in the visual part? (Either by counting blanks or adding zeros)
Br
Stian
Solved! Go to Solution.
Ok understand it....
-Goto Edit Queries From Home Tab
-Select Column which has NULL Values
-Click on Replace Values
-Replace 'null' values with nothing
-Click 'OK'
-Close & Apply
Now you will see blank values in Donut Chart
what DAX can we equate this to? - for those who want to know?
What Visual you are working on ???
You can see blank Values with counts unless you have Page /Report/Visual Level filter applied on it for blank values
Hi,
This is how it looks for me:
Ok understand it....
-Goto Edit Queries From Home Tab
-Select Column which has NULL Values
-Click on Replace Values
-Replace 'null' values with nothing
-Click 'OK'
-Close & Apply
Now you will see blank values in Donut Chart
Hi and thanks for the assistance.
This worked fine when I use excel as data source, but my real data uses direct queries from an sql database / view. That's probably why I need to figure out how to create a meaure that prints 0 instead of "null"
Then you should use ISNULL/COALESCE in SQL queries to handle Null Values.
Forgot picture
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |