Bar Graph that can Toggle between Absolute Variance and % Variance from Prior Year

[hstgeorge]

I have built a dynamic slicer to toggle between Absolute Variance and % Variance from PY.

I have also built a toggle for WTD, MTD, QTD, and YTD.  

I have a separate measure for each so, I have ABS Var WTD, % Variance WTD, ABS VAR MTD, % Variance MTD, ETC.

I then used and If(and) statement to tell it what measure to use using SelectedValue combinations.

My problem is that the number is only capable of showing in one format.  I am not sure how to get it to show in % for Variance and decimal number for ABS VAriance.  You can't using the FORMAT command because it converts the number to text and then you can't place it on a bar chart in the Values area.  

Is there any way to do this or an easier way that I am not thinking about.  Thank you!!!

[amitchandak]

@hstgeorge , I doubt there is fix as of now for dynamic data type and data format.

Refer to the idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32728060-dynamically-set-formatti...

Vote for similar idea's

I think you already have a solution for slicer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Week:https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

other : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intell...