Power Bi report for every product from a certain category

[louisquinet]

Hello

I would like to make a Power BI report for every category from my excel. Every report from a certain category should show a graph for every product within that category.

It is easier to show with an example:

So I would like a report for Category A: this report should contain a graph from product 1 and product 2 (two left graphs).

And I would like a report for Category B: this report should contain a graph from product 1 and product 2 (two right graphs).

Thank you in advance

Louis

[PijushRoy · Accepted solution]

Hi @louisquinet 

Please create 4 visuals (as you mentioned)
then use the Visual Level filter separately for all 4 visual
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter?tabs=powerbi-de...

for 1st visual, category = 4 and Product = 1

If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Lets Connect Linkedin

[louisquinet]

Thank you very much!