Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

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 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.

6 REPLIES 6

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.

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

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.

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:

 

pmreis_1-1697027918484.png

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

 

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
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.