ANY IDEA HELPS, PLEASE

[theybasar]

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 

[rsbin · Accepted solution]

@theybasar,

Have you tried any of the custom Calendar visuals?

[theybasar]

Did not know it and helped me a lot

[SteveHailey]

Hello @theybasar. 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

[theybasar]

@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 Result

And then set the column color formatting to that measure:

[TomMartens]

Hey @theybasar ,

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

[theybasar]

@TomMartens  it is like that data. 

[theybasar]

<top> Here link and I hope you will see it. 

[TomMartens]

Hey @theybasar ,

the link requires a login, I will not do that!

Consider providing a link that allows accessing the file without login.

Regards,

Tom

[theybasar]

Good morning @TomMartens , 

I am sorry, I did not see it was a private share. Here is the link and anyone can edit and see it.  Looking forward to hearing from you hopefully very soon.

https://docs.google.com/spreadsheets/d/1gb8HH7ZCOyXg4oaFFhyV0L1AMgYQvVa7/edit?usp=sharing&ouid=11842... 

Thank you, 

Yavuz

[v-stephen-msft]

Hi @theybasar ,

I quite agree with @SteveHailey 's workaround. If you also want other visuals, I found this for you, I don't know if you are satisfied. It's called Calendar by Tallan.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[theybasar]

@TomMartens thank you so much. I will share it.