Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
In the model and Properties pane how - what could i add to show my percentages as (23%).
Solved! Go to Solution.
Hi @Anonymous
(1)You need change the data type of the value to text in Power Query .
(2)Then create a column to add “()” for the value .
(percentage) = FORMAT("(" & SELECTEDVALUE('Table'[Column1]) &")","")
(3)Configure conditional formatting for the value .Choose the column[(percentage)] in fields ,and select Gradient in Format style .
The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
Hi @Anonymous
(1)You need change the data type of the value to text in Power Query .
(2)Then create a column to add “()” for the value .
(percentage) = FORMAT("(" & SELECTEDVALUE('Table'[Column1]) &")","")
(3)Configure conditional formatting for the value .Choose the column[(percentage)] in fields ,and select Gradient in Format style .
The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
@Anonymous ,
Refer