Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Guys,
I've created a line Chart by using two measures:
Blue line
Green line
The line chart result is as follows:
How can I make sure the blue line which has a value of ZERO in P5 is pulled through?
Is that possible with a measure?
I know that some things unfortunately aren't possible with Measures in PowerBI.
Thank you!!!
Solved! Go to Solution.
Your issue is that the count function returns null instead of 0 if there are no values. So, you need to modify your formula with an IF statement to allow it to return 0 when the count is 0. The formula is below.
Hi nsexton12,
Thank you very much for your help. I will try the advised formula for my learning process.
I literally just sorted the issue slightly differently:
NEW formula Blue line:
Keep learning.
Hi nsexton12,
Thank you very much for your help. I will try the advised formula for my learning process.
I literally just sorted the issue slightly differently:
NEW formula Blue line:
Keep learning.
Nice! There are always many ways to solve each problem. Could you please mark my reply as a solution if it worked for you?
Yes, It did work. Took a little longer as I'm new to PBI and tried to apply it to my situation.
Thank you!!!
Your issue is that the count function returns null instead of 0 if there are no values. So, you need to modify your formula with an IF statement to allow it to return 0 when the count is 0. The formula is below.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |