Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Changing matrix visual with hierarchy slicer

Hi all,

I am new to Power BI and would really appreciate some help with what I'm trying to achieve. Have tried to figure something out, but unable to find a solution yet. 

I have a data set (sample) consisting of the following hierarchy: 

 

In a matrix, if I select any one (or more) of the categories at the lowest level using the slicer (i.e Ferrari, Honda,...,Black,...,Orange, Pineapple etc) I want there to be an individual column for each of the lowest level categories selected in the matrix, as seen below:


Therefore if my selections are as follows, then I want the matrix to display the columns as seen below (with the values in the matrix being the sales for each column category at each individual shop)

 

If however, I make selections for the upper level categories (i.e Cars, Colours, Fruits..), I want the following matrix display, where Cars includes the sum of Ferrari, Honda, Mitsubishi and Toyota under a single column called "Cars" and similarly for Fruits. 

 

Similarly, if Cars, Colour and Fruits are all selected - I want a single column (titled "Sample") displaying the sum of Cars, Colour and Fruits. 

Thank you!!

5 Replies