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
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.
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 |
---|---|
4 | |
4 | |
3 | |
2 | |
2 |