Need idea on Visualization

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

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