Hide / un-hide un-wanted Column in Matrix Visualization

[Anonymous]

 Hello, I am beginner of Power BI. I would like to know below is feasible or not. In my Matrix Visualization, it contains Quarter and by Month data,  I would like to un-show Jan-Mar data, and only show Q1 total, and keep Apr-May, Q2 total, and also un-show Grand Total of Q1+Q2 Total.

 Screen captured shown as below. I am not sure is it feasible in Power BI.

Thanks!

BeforeAfter

[GilbertQ · Accepted solution]

Hi there, this could be possible, but it would entail using quite a few measures that are used to build the final measure which could display what you want above.

But as I said it is rather complex and would take some time to implement and get correct.

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

In matrix visual, there is no OOTB feature for us to hide specific columns and each added measure will be added to each column group.

To work around the issue, you need to transform data in Query Editor firstly. You can download attached .pbix file.

1. You can duplicate the original query, then use Group BY feature for that copy to return total value.

2. Then use Append Queries as New feature to append this new table with original one.

3. Replace null as "Total". Apply the changes.

4. Create a matrix with visual level filter by Month.

Best Regards,
Qiuyun Yu

[Anonymous]

Thanks all, I would try those suggestion.

[GilbertQ · Accepted solution]

Hi there, this could be possible, but it would entail using quite a few measures that are used to build the final measure which could display what you want above.

But as I said it is rather complex and would take some time to implement and get correct.