Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 47 | |
| 44 | |
| 40 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |