Forum Discussion

Sanblas26's avatar
Sanblas26
Regular Visitor
9 years ago
Solved

Showing percentage values in visuals

Hi All,   I am new to power BI and I have a clarification regarding how to show % in my visual. I use a free desktop version. I want my visual to change colors based on the value, since I have the...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Hi Sanblas26

     

    Your first picture is from the Query Editor - that's where you've set to %

     

    You'll have to do the same in the Data/Report View - select the Percentage Column - go to Modeling Tab - Format: Percentage

     

     

    Hope this helps! :smileyhappy:

     

smibrahim's avatar
smibrahim
Frequent Visitor
7 years ago

I am facing the same problem. My Data Source is Sql Server Table.

Power Query Editor has the data marked as Percentage (Datatype) but this is not reflecting in the Power BI Visualization (either in Table or in other Reports).

Query Editor and Visualization

 

 

smibrahim's avatar
smibrahim
Frequent Visitor
7 years ago

Its working. After selecting the " Specific Column" under "Fields" pane.