This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I have the below measure being used to allow a user to change the metric being displayed on a bar chart. I cannot get any type of conditional formatting to work on the index 1 and defaul values that allow them to be displayed as a percentage. How can I accomplish this? I tried wrapping this
COUNT('Complete Results'[Recipient Email]) / CALCULATE (COUNT('Complete Results'[Recipient Email]),ALLSELECTED())*100
in Format(Value,"Percent") and some otehr things I found on the forums, but none of them seemed to work.
Any help is appreciated.
According to this post it is not supported https://community.powerbi.com/t5/Desktop/Creating-a-dynamic-chart-with-formats-Number-and-Percentage...
Are there any workarounds or another way I can accomplish teh same results?
Solved! Go to Solution.
@ZHelbert2277 , Create measure like this
COUNT('Complete Results'[Recipient Email]) / CALCULATE (COUNT('Complete Results'[Recipient Email]),ALLSELECTED())
From measure tool , option you will see once have measure selected in fields pane. You can mark it as % (There is a symbol)
refer here
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-measures#organizing-your-measures
Second, if you are using a measure slicer prefer field parameters or calculation groups
@ZHelbert2277 , Create measure like this
COUNT('Complete Results'[Recipient Email]) / CALCULATE (COUNT('Complete Results'[Recipient Email]),ALLSELECTED())
From measure tool , option you will see once have measure selected in fields pane. You can mark it as % (There is a symbol)
refer here
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-measures#organizing-your-measures
Second, if you are using a measure slicer prefer field parameters or calculation groups
I will try this and see if it works, thank you!
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 15 |
| User | Count |
|---|---|
| 61 | |
| 36 | |
| 29 | |
| 22 | |
| 22 |