Convert the matrix visual to clustered bar and line chart on Power bi

[soumyaiyer]

Hi

Need help with converting the matrix visual to clustered bar and line chart on Power bi.

Below is the snap shot of the matrix. 

Thanks!

 

[Anonymous]

Hi @soumyaiyer 
I wanted to check if you had the opportunity to review the information provided by @rohit1991 . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

Hi @soumyaiyer 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[rohit1991 · Accepted solution]

Hi @soumyaiyer ,
To convert the matrix visual shown in your screenshot into a clustered bar and line chart in Power BI, you'll need to restructure the data and use appropriate chart combinations.

The matrix currently presents data by year, quarter, and month, breaking down the counts and percentages of "Met" and "Not Met" performance metrics. To build the clustered bar and line chart, start by unpivoting the data in Power Query so that the categories (e.g., "Met Count", "Not Met Count", "Met Percentage", etc.) become individual rows under a "Metric" column, with corresponding "Value" entries. In Power BI, use the clustered bar chart to represent the "Met Count" and "Not Met Count" side by side for each month, and overlay a line chart for "Met Percentage" (or both percentages if desired). 

You’ll use the shared axis (Month or Date hierarchy) and assign different Y-axes: one for count and another for percentage. This visual combination allows for clear comparative analysis of performance counts alongside the rate at which targets were met or not met over time.