cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
othy_bi
Responsive Resident
Responsive Resident

Matrix breaks using a level with Report Builder

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).

othy_bi_1-1638294377217.png

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: 

othy_bi_2-1638294590947.png

 

Any suggested solution would be appreciated. 

Thank you in advance.

6 REPLIES 6
v-kalyj-msft
Community Support
Community Support

Hi @othy_bi ,

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

othy_bi
Responsive Resident
Responsive Resident

Hi @v-kalyj-msft 

I do appreaciate your feedback.

Actually I was trying to acheive that need on Report builder.

 

Thank you for your time.

v-kalyj-msft
Community Support
Community Support

Hi @othy_bi ,

According to your description, here’s my solution.

1.Create two matrices with the same data.

vkalyjmsft_0-1638513192763.png

 

2.Sparately put the column country to two visual filters and select A for one and B for another.

For Country A:

vkalyjmsft_1-1638513192766.png

 

For Country B:

    

vkalyjmsft_2-1638513192768.png

 

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.

AlexisOlson
Super User
Super User

You can do this by nesting a matrix inside of a list.

AlexisOlson_0-1638460288997.png

The list groups on Country and matrix inside the list groups on Category and Product.

AlexisOlson_1-1638460465689.png

See the sample .rdl I've attached.

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.

othy_bi
Responsive Resident
Responsive Resident

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. 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors