Visual Help Needed

[user900]

I am trying to deelop a visual to align with the following format:

Current month = this month

Previous month = last month

Historical = the month preceding last month

Historical = the month prior to the previous historical month

Effectively, I will have a 4 month trend. The color of the preceding 'dots' in those fields represent the position of the data point in relation to the A, T, L thresholds scale. For example, for Metric Name 2, current and previous months exceed the L threshold of 7%, thus marked as red. The first historical month value of 3.06% falls between A and L, categorixing it as T or yellow. The final column is equal to A, or represented as green. The black dot in the A, T, L thresholds section represents the position of the current month's data point relative to to the percentages.  The dot must adjust to the correct position based on current month's results. The count of months exceeding the threshols will equal how many months resulteing in either red or yellow, but once marked green, the count resets to zero (I knowthis can be done using a measure)..

What type of chart would I use and how would I get the colored dots and bars to resemble the example above?

Any help is appreciated.

~new user 900

[Anonymous]

Hi @user900 

Thank you suparnababu8 for your positive response to this post.

suparnababu8 shared awesome learning resource about conditional settings in matrix visual, if this helped you to solve your problem, please consider accepting his reply as a solution, it will make it easier for other users with the same problem to find a solution.

You can also refer to this link about Apply conditional table formatting in Power BI - Power BI | Microsoft Learn.

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

[suparnababu8 · Accepted solution]

Hello @user900 

You can use default Matrix Chart to meet your requirement. Please go through below URLs. It might helps you.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-matrix-visual?tabs=powerbi...

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-matrix-visual-format-setti...

https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-on-row-level-data-of-matrix...

https://youtu.be/T6jZFMsP_yI?si=z-JYS72ujB9Q5MVX

Thanks!