Forum Discussion

Revathi_Kannan's avatar
Revathi_Kannan
Helper I
2 years ago

Need idea on Visualization

Hi all,   I have 3 columns on my Data model which is Countries, TAX which will have "Present" & "Not available" string & Customer code (Unique). I need present the report to the customers wherein i...
Need Help
Revathi_Kannan's avatar
Revathi_Kannan
Helper I
2 years ago

Hi pmreis ,

 

I have been created the above 2 measures but i am not getting the desired result.

 

I have dragged the Guage visualization. Now please assist me which column should be dragged under which field.

pmreis's avatar
pmreis
Most Valuable Professional
2 years ago

Hi!

 

  1. Use a table or matrix visualization in Power BI.
  2. Add the "Countries" column to the Rows or Axis.
  3. Add the "Category" measure to the Values.
  4. Use conditional formatting to color the cells based on the category:
    • "Unacceptable" - Red
    • "Average" - Yellow
    • "Good" - Green