Forum Discussion
Helper IIDashboard Tiles with conditional formatting
Hi,
Can anybody suggest a way in which I can display a tile on a dashboard which shows a conditional background colour? At the moment I have card visuals in my PBIX with conditional formatting to show the background colour as either Red, Amber or Green (depending on the result) but when I show this on the dashboard the background colour shows as white which is really unhelpful.
Are there are workarounds for this?
Thanks
Chris
There is a workaround but you won't like it. Instead of pinning a visual to a tile you can pin the entire page to a tile.
Create a small-ish page that has your visual, and a page background color controlled by your condition, and then pin that page to the tile.
Not actually sure if this works - maybe there's a bug in the mix here too?
Hi nunnc01
You may want to change your card tile background by conditional formatting.
I have a test build a card visual and pin it to my dashboard.
It will show white background instead of color in Rule.
It seems that card tile won't show any other background color except white.
I found that if we open this card tile in focus mode, it will show backgrond color.
If you want to show dynamic background color by conditional formatting, you may need to use filter or slicer.
However we couldn't pin slicer into dashboard and tiles cannot interact with each other in dashboard.
In addition to lbendlin 's reply, you can try pin live page into dashboard it is a good way.
Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：Tile background colourOr you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- lbendlin
Super User
There is a workaround but you won't like it. Instead of pinning a visual to a tile you can pin the entire page to a tile.
Create a small-ish page that has your visual, and a page background color controlled by your condition, and then pin that page to the tile.
Not actually sure if this works - maybe there's a bug in the mix here too?
Hi nunnc01
You may want to change your card tile background by conditional formatting.
I have a test build a card visual and pin it to my dashboard.
It will show white background instead of color in Rule.
It seems that card tile won't show any other background color except white.
I found that if we open this card tile in focus mode, it will show backgrond color.
If you want to show dynamic background color by conditional formatting, you may need to use filter or slicer.
However we couldn't pin slicer into dashboard and tiles cannot interact with each other in dashboard.
In addition to lbendlin 's reply, you can try pin live page into dashboard it is a good way.
Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：Tile background colourOr you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This solution of pinning the whole report to dashboard doesn't work.
The whole point of pinning tile to dashboard, in our case is to alert the Production Workers that something is seriously wrong in a live dashboard that is updated via Streaming "Push Dataset"
So, the line workers need to see glaring RED when a dashboard number goes below a certain threshold. Please upvote this feature request. https://ideas.powerbi.com/ideas/idea/?ideaid=f4c224ae-070f-456b-9c9e-4389ce17675b
Hi nunnc01
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Rico Zhou
The only option I have found so far is to use the table visual for a measure ( which will only show your one value) and then do conditional formatting on the cell background. You can then pin this to a dashboard. It doesn't look as nice as a card visual with conditional formatting but it at least allows you to show RAG status on a dashboard.
