The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi guys,
I have a matrix visual which based on the slicer selection shows percent or values. The issue is formating values should be whole number, precent should have % .
The data model has the column with all values, and the column with type of value (percent, value, denominator).
Use dax to show values:
I have measures: KPI Value, KPI percent.
Is there way I can modify this formula so it can switch between precent and values and formating?
Many thanks!
Solved! Go to Solution.
If anyone have similar task, I've done it by using SWITCH and SELECTEDVALUE (based on slicer) then FORMAT (value).
Hi @Anonymous
I am so glad to hear that you have done it with your workaround . Please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ Ailsa Tao
If anyone have similar task, I've done it by using SWITCH and SELECTEDVALUE (based on slicer) then FORMAT (value).
@Anonymous , if you are using measure slicer and want the format has to change, you need to use calculation group
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
Thank you @amitchandak
Unfortunately, due to company policies I don't have tabular editor or external tools in Pbi.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |