Forum Discussion
Conditional Formatted "Blocks"
Hi,
I am looking for a visual which gives me the below. It is conditional formatted to show green within target and red outwith target etc.. I can use a table but I will need to customise it so just asking if there is an easier solution. TIA
Hi yaman123 ,
Given your requirements, I'd recommend exploring the use of KPI visuals in Power BI. KPI visuals are designed specifically for scenarios like yours, where the goal is to visually represent the performance of a metric against a target.
In the KPI visual, you can set the color for when the value is above or below the target.
For more information on KPI visuals and how to set them up, please refer to this documentation:
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
If the KPI visual does not meet all your needs, another approach could be to explore Custom Visuals from the Power BI Visuals Marketplace. There are visuals designed for advanced conditional formatting and data representation, such as the Card with States by OKViz, which might offer the flexibility you're looking for.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Can you please share your model, data and rules for conditional formatting ?
Hi yaman123 ,
Given your requirements, I'd recommend exploring the use of KPI visuals in Power BI. KPI visuals are designed specifically for scenarios like yours, where the goal is to visually represent the performance of a metric against a target.
In the KPI visual, you can set the color for when the value is above or below the target.
For more information on KPI visuals and how to set them up, please refer to this documentation:
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
If the KPI visual does not meet all your needs, another approach could be to explore Custom Visuals from the Power BI Visuals Marketplace. There are visuals designed for advanced conditional formatting and data representation, such as the Card with States by OKViz, which might offer the flexibility you're looking for.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
