Forum Discussion
ANY IDEA HELPS, PLEASE
Simple requirment is we need to create a visualization that it will have two variables:
1- Error Rates ( 0-5 (green), 5-20 (yellow), 20-50( orange), 50-100( red))
2. Date (mm/dd/yyyy)
So, this visualization has to display everyday different color depend on Error Rate. I thought Brick Chart visualization is the right one, but I could not do it and now I wonder if anyone is rellay can help me for this problem.
Thank you
Anonymous,
Have you tried any of the custom Calendar visuals?
12 Replies
SteveHaileySolution Specialist
Hello Anonymous. You can use a simple Table visual, and use Conditional Formatting to change the background color of the error rate.
The conditional formatting parameters would look something like this:And the results would look like this:
I created a sample .pbix and it is linked here, in case it's helpful.
Here's a link with more info about conditional formatting. The "Color by rules" section would be most relevant here.Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs
-Steve
SteveHailey Thanks for reply, I have done it but they did not want simple table so that I am really into something little different. Any other idea?
- SteveHailey
Perhaps a bar chart?
To format the bars, I created a Measure as seen below:Error Rate Formatting for Bar Chart = VAR ErrorRate = SELECTEDVALUE( Data[Error Rate] ) VAR Result = SWITCH( TRUE(), ErrorRate < 5, "Green", ErrorRate < 20, "Yellow", ErrorRate < 50, "Orange", "Red" ) RETURN ResultAnd then set the column color formatting to that measure:
- rsbin
Community Champion
Anonymous,
Have you tried any of the custom Calendar visuals?
- TomMartens
Super User
Hey Anonymous ,
consider creating a pbix that contains sample data, but still reflects your data model (tables, relationships, calculated column, and measures), upload the pbix to onedrive or dropbox and share the link.
If you are using Excel to create the sample data instead of the manual input method share the xlsx as well.
Describe the expected outcome based on the sample data you provided.
Regards,
Tom
TomMartens thank you so much. I will share it.
<top> Here link and I hope you will see it.
- TomMartens
Hey Anonymous ,
the link requires a login, I will not do that!
Consider providing a link that allows accessing the file without login.
Regards,
Tom
