Please Need help - Daily different Colors should display Error Rate

[theybasar]

Hi,

Please tell me how can I create a Brick chart which wull be display daily error rates. Requirement is color has to be differ depend on Error Rate for each day. but I could not do it, I highlited on screenshot that I can not move measure to category section. Please if you have any idea, or other visuatlions like that I can use for each day to display with different colors conditions with Error Rate. Lookinf forward to hearing.. Thank you

@v-yalanwu-msft,

@v-chenwuz-msft,

@amitchandak, 

[v-yalanwu-msft]

Hi, @theybasar ;

Maybe matrix and then conditional formatting would do the trick.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @theybasar ;

As far as I know, measure usually can't be put in category, it's usually put in value.

Second, you can create a column or a table as a category and then create measures for each category.
And I'm not familiar with the visual objects in your diagram. What do you want the output to look like? Treemap you can try whether it meets your needs?
If none of the above methods meet your expectations, can you share a simple file after removing sensitive information and the output what you want?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[theybasar]

Good Morning @v-yalanwu-msft ,

To be honest, the requirement is to create an Error Date Visualization with days. (Error Rates 0-5 Green, 5-20 Yellow, 20-50 orange and 50-100 Red colors ). Each day will be displayed different color (error rates). I thougt Brick Chart could be a good idea but not really. Attached is the sample data. Looking forward to hearing from you. 

Please feel free to share your idea and smaple power bi doc. 

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

Thank you, 

Yavuz