category , year and sales

[powerbiexpert22]

how to create below view in power bi ?

[Anonymous · Accepted solution]

Hi @powerbiexpert22 ,

Thanks @sergej_og  for the quick reply and solution. I have some additions to this:

As you mentioned you are having trouble creating visual objects, there are no charts in PBI Desktop exactly like the one in your screenshot, we usually create line charts like this.

(1) This is my test data. 

(2) We can create a line chart.

(3) If you want a chart more similar to the one in the screenshot, then we can create three line charts. Then select the different Categories in the Filter pane, then change the position of the legend in the [Format your visual] pane, and finally group them together.

Please refer to my pbix file.

Best Regards,

Neeko Tang

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

[powerbiexpert22]

Hi @sergej_og ,

data model and measure creation is already done, I am not sure how to create such type of visual in Power BI

[sergej_og]

 - Connect to the data
 - Create a data model
 - Create measures + visual
 - Deploy to service
...