Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I have been trying to replace Blank values as 0 in my matrix visualisation. I have tried using +0 in a new measure and dax functions but no luck. Below is an example of my data and what i am trying to do. Please share your ideas!!
Direction | Category | Date |
I | 1 | 17-Jun |
B | 2 | 18-Jun |
B | 3 | 17-Jun |
I | 1 | 18-Jun |
I | 2 | 20-Jun |
I | 4 | 21-Jun |
B | 5 | 19-Jun |
I am trying to add values as "0" when the count of category for a specific date is null.
Thanks in advance!
Adding 0 to a number/measure (like COUNT) always forces the display of a number. ALWAYS. The fact that you can't see 0's in your matrix points in a different direction. I'd check the formatting of the values in the table. Maybe 0's are formatted as BLANKS by the matrix? Can you check some other visuals?
Best
Darek
What is the measure you are currently using to fill this table? What measures using the +0 trick have you tried?
Hi @Cmcmahan
I have used the following dax:
count = count([category]) + 0
count = if(isblank(count([category)),0,count([category]))
Child Count = VAR rowcount = COUNTROWS ( Child ) RETURN IF ( rowcount = BLANK (), 0, rowcount )
ActualM = IF ( CALCULATE ( SUM ( Expenses[Actual] ) ) = BLANK (), 0, CALCULATE ( SUM ( Expenses[Actual] ) ) )
Using your first measure (count = count([category]) + 0), I was able to get this:
Could you share a screenshot of the fields you have in your Rows/Columns/Values buckets in the visualization pane?
I have also used the same measure in the above screenshot. I tried performing the same for various sets of data i have but still end up getting the same. If i am changing count = count([category])+0 to count=count([category])+1, only the fields in the table withvalues get updated and the blank values remain the same.
[Category Count] = DISTINCTCOUNT( T[Category] ) + 0
Always use the name of the table in front of the column. ALWAYS. And never do that in front of measures. NEVER.
The behavior you're talking about is abnormal. Please restart Power BI.
Best
Darek
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
26 | |
20 | |
18 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
24 | |
22 | |
21 |