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 ,

 

Thank you so much for your response. I have already implemented the stacked column chart.

 

I thought of implement Guage Visualization based on the below threshold.

 

1. Eg. If the country IN has overall count 1000 and Not available data is 500 then my guage should have the final value as 1000 in which 50% has Not available data.

 

Thresholds:

1. More than 80% - Unacceptable (Red)

2. between 59 to 79 - Average (Yellow)

3. Below 59% - Good (Green)

 

Can you assit me how to do it.

pmreis's avatar
pmreis
Most Valuable Professional
2 years ago

Hi Revathi_Kannan , glad to hear it worked out!

 

For the gauge, I recommend to not use it as it's very limitative. Use instead another visual such as "bullet chart", in which you can specify thresholds according to reaching a value as you need.


Example:

 

How to implement it: power-bi-bullet-chart



Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn