Forum Discussion
Volume and Amount ($) Year to Year Visualization Help
Hi all,
I have a visualization I need to improve. This visualization is for looking at the amount of quotes delivered to customers and what was the acumulated value of those quotes every period. By now, I am able to shou correctly the comparison between the volume of offers delivered. But when it comes to showing the lines, that represent the amount quoted, 'm not able to show it correclty.
I created 2 measures of quoted value. 1 for each fiscal year. Problem is, they both appear always in each period... So for example the one of FY21 appears in all periods with a 0 value... that's not useful at all.
What is the best way to generate such visualization? Or even to make it smart enough so that I don't need to adjust it every year to measure each amount of fiscal year... instead for it to generate the differences of each year by itself?
This is the following visualization configuration I'm using.
Please help!
Regards,
Anonymous For you measure that is returning zero values that you don't want, try something like:
Measure = VAR __Calc = <some calculation> RETURN IF(__Calc = 0,BLANK(),__Calc)Otherwise, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
1 Reply
- Greg_Deckler
Community Champion
Anonymous For you measure that is returning zero values that you don't want, try something like:
Measure = VAR __Calc = <some calculation> RETURN IF(__Calc = 0,BLANK(),__Calc)Otherwise, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.