Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Is it possible to format the slicer to display as a percentage instead of a decimal, the data is entered as a percentage, in the table, but appears as a decimal on the slicer
Solved! Go to Solution.
I can see you've set the Target % Column to % in the Query Editor but
you'll have to do the same in PBI as well as you'll notice there's no Data Type % in PBI. (unlike the Query Editor)
So go to the Modeling tab select the Target % Column and change the Format to Percentage!
(Data Type would be decimal in your case)
Hope this helps!
I can see you've set the Target % Column to % in the Query Editor but
you'll have to do the same in PBI as well as you'll notice there's no Data Type % in PBI. (unlike the Query Editor)
So go to the Modeling tab select the Target % Column and change the Format to Percentage!
(Data Type would be decimal in your case)
Hope this helps!
Sean, Still I am facing the problem after making above changes, can anyone provide proper solution as I am also facing same problem.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |