The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I created a chart which shows the percentage difference over months. If the base value is zero then it doesn't show any value. I'm really nor sure what I'm misisng here. Please see below:
I used one of the quick measures:
Solved! Go to Solution.
Hi, @HamidBee
I made a mistake in the code, I have modified '__BASELINE_VALUE' to '__VALUE_TO_COMPARE'. You can check it.
I respect your decision, if you change your mind and have other problems, you can feel free to ask me. And
Hi, @HamidBee
As long as there is a 0 in the divisor or dividend, the result is 0. So what's your confusion?
I downloaded your sample and found no problems. Is this(create a column:[A]-[B]) what you want?
If not, What's your desired result?
Thank you. I would like it to display the percentage increase even if the base value is zero. For example in April it went from 0 to 21 but it doesn't calculate a percentage increase.
Hi, @HamidBee
You haven't replied to me, I don't know if your problem has been solved.
I asked you before, not that the problem is difficult, but I don’t know what the result you want is, according to your code, logically it should be 0...
If your want is: when __BASELINE_VALUE is 0, the percentage increase shows __VALUE_TO_COMPARE, you can try Like this:
PD.Mixed =
VAR __BASELINE_VALUE =
SUM ( '2020'[Mixed] )
VAR __VALUE_TO_COMPARE =
SUM ( '2021'[Mixed] )
VAR percentage =
IF (
NOT ISBLANK ( __VALUE_TO_COMPARE ),
DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE )
)
RETURN
IF ( percentage = BLANK (), __VALUE_TO_COMPARE, percentage )
Apologies, I've just bene drowning with work lately. I've given it some thought and I agree with you. From a mathematical point of view their is no numerical increase if the baseline value is zero. In all of my years working with numbers this is the first time I've come across this question. I'll leave it as it is for now, unless their is a way to put "null" if the baseline value is zero.
Hi, @HamidBee
I made a mistake in the code, I have modified '__BASELINE_VALUE' to '__VALUE_TO_COMPARE'. You can check it.
I respect your decision, if you change your mind and have other problems, you can feel free to ask me. And
@HamidBee Can you share your desired result or your calcultion logic? I don’t understand what percentage increase you said should be presented in the visual.
@HamidBee , Mark it as %, from measure tools (Click on the measure you will see that). Also, use bar and line visual with secondary axis enabled
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
Are you referring to this as it seems it was already on percent:
It seems it hasn't resolved the issue:
Also, is this what you mean by bar and line visual:
@HamidBee , I meant line and clustered column visual.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi
I am attaching a saple pbix file which mimicks the same problem.
https://www.mediafire.com/file/nkqwwlutrgwn5e8/Percentage+Problem.pbix/file
Thank you,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |