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 


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