Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hope someone knows the answer. I have a slicer of indicators.
Indicators are a percentages or a number.
For example: 2 indicators: accidents is a number and penalty is a percentage.
On the y-aces in the bar chart I want see a percentages when I selected penalty
and see a number when I selected accidents. Thanks a lot for answering
Solved! Go to Solution.
Super, I tried this tomorrow! I let know of it works!
Super, I tried this tomorrow! I let know of it works!
@Greg_Deckler Thanks, for your answer. I selected with a slicer accidents versus penalty. I use the same measure, sum(value). I don't use fieldparameter. Is that the solution?
@Margreet OK, if that is the case, then Dynamic Format String is your answer. Basically, you are going to write it like this:
VAR __Item = MAX('Table'[Indicator])
VAR __Result = IF( __Item = "accidents", "0", "0.00%;-0.00%;0.00%"
RETURN
__Result
Dynamic Format Strings for measures is a Preview feature that you will have to turn on in the desktop. Once you turn it on then in Measure tools when you select your measure, in the Formatting area of the ribbon, use the Format dropdown to select Dynamic and then paste in your DAX code.
@Margreet Hard to be certain of the solution given the information provided. How are you selecting accidents versus penalty? Are you using Field parameters? Are the indicators (values) the same measure or two different measures? Could be a use case for dynamic format strings.