Need idea on Visualization

[Revathi_Kannan]

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 it should have the following requirement. Kindly assist me the perfect visualization to complete this.

1. For each countries they needs to see the overall count with % of Present & % of Not available values.

2. As per my visualization they should be able to know which countries they needs to focus on to improve the quality.

Please assist me.

[Revathi_Kannan]

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]

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

[Revathi_Kannan]

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]

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

[pmreis]

Hi @Revathi_Kannan 

You can create something along these lines in your country table (assuming you have a separate table connected to the main fact table)

Present Percentage = 
DIVIDE(
    COUNTROWS(FILTER(YourTableName, YourTableName[TAX] = "Present")),
    COUNTROWS(YourTableName),
    0
) * 100

 
Then you can bucket the countries within categories:

Category = 
VAR PresentPct = [Present Percentage]
RETURN
IF(PresentPct > 80, "Unacceptable",
    IF(AND(PresentPct <= 79, PresentPct >= 59), "Average",
        "Good"
    )
)

Finally, use conditional formatting to allocate a color to each category.

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

[pmreis]

Hi @Revathi_Kannan 

You can use a Stacked Column Chart for this purpose, with the following configuration:

• X-axis: Countries
• Values: Count of "Present" and "Not available" from the TAX column.
• This will give you bars for each country, divided into two segments: "Present" and "Not available". The height of each segment will represent the count.
• You can enable data labels to show the exact count and percentage for each segment.

• Color Coding:

  • Use contrasting colors for "Present" and "Not available" (e.g., green for "Present" and red for "Not available"). This will quickly highlight countries with a higher percentage of "Not available" values, indicating where to focus for quality improvement.

With this visualization, viewers can easily compare countries based on the percentage of "Present" and "Not available" values, helping them identify areas that need attention.

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