The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have the graph pictured above. I want to display the variance % between the data points. The data points above have been calculated as the % share between two variables in a column that has 5 variables. For example the column has factors 1,2,3,4,5. The data points on the above selected graph are the % share between factors 1 and 3. How would I go about this? I've tried with the quick measure function however I've had no luck.
Solved! Go to Solution.
Hi @ollie2110
1. Create a measure for Variance % with the following DAX:
([Restrictive Booking %] is the measure you are currently using in your chart)
Variance % =
VAR CurrentValue = [Restrictive Booking %]
VAR PreviousValue = CALCULATE([Restrictive Booking %], PREVIOUSMONTH('Table'[YearMonth]))
RETURN
IF(NOT ISBLANK(PreviousValue), DIVIDE(CurrentValue - PreviousValue, PreviousValue, 0) * 100, BLANK())
2. Use Variance % as “Tooltips” for your chart visual.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ollie2110
1. Create a measure for Variance % with the following DAX:
([Restrictive Booking %] is the measure you are currently using in your chart)
Variance % =
VAR CurrentValue = [Restrictive Booking %]
VAR PreviousValue = CALCULATE([Restrictive Booking %], PREVIOUSMONTH('Table'[YearMonth]))
RETURN
IF(NOT ISBLANK(PreviousValue), DIVIDE(CurrentValue - PreviousValue, PreviousValue, 0) * 100, BLANK())
2. Use Variance % as “Tooltips” for your chart visual.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
So I decided to use the Month-on-month Quick measure which seemed to work well. Its an issue of displaying the variance as opposed to calculating it. I Would like to display the variance % in the red-lined areas as opposed to the secondary dark blue line.
Plz share sample dataset
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |