Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I have the below dataset, using report builder, I have created a matrix to visualize Revenues (values) per Category (Rows) per Products (Columns).
I am wondering if there is a solution to split the matrix using the country level, here is an idea of what I want to achieve:
Any suggested solution would be appreciated.
Thank you in advance.
Solved! Go to Solution.
Hi Community,
In case you had the same need as mine.
In order to be able to split a matrix by a level, what you need to do is to put your matrix inside a List, then add the group you want to use to split your matrix ( example: Country) in the List settings.
Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated
Hi @DataVitalizer ,
Did my solution solve your problem? If yes, please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ kalyj
I do appreaciate your feedback.
Actually I was trying to acheive that need on Report builder.
Thank you for your time.
Hi @DataVitalizer ,
According to your description, here’s my solution.
1.Create two matrices with the same data.
2.Sparately put the column country to two visual filters and select A for one and B for another.
For Country A:
For Country B:
Below is my sample attached.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
There @Syndicate_Admin
Thanks for your reply, actually this is the solution I have applied, I guess something is missing here because when I add a continent (which is a column in the same Dataset) as a parameter and rendered my report I get this error message:
No parameter matching for multivalued placeholder
Query execution failed for dataset 'Dataset Name'.
An error occurred while processing the report.
An error occurred while processing local reports.
Thank you in advance.
Hi Community,
@amitchandak , @AlexisOlson , @Greg_Deckler and @PhilipTreacy as long as you are the Top Solution Authors from Last month please allow me to mention you in this post.
Any suggestion about the issue described in the previous message would be appreciated.
Thank you in advance for your time.
Hi Community,
In case you had the same need as mine.
In order to be able to split a matrix by a level, what you need to do is to put your matrix inside a List, then add the group you want to use to split your matrix ( example: Country) in the List settings.
Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |