The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Before
After
Solved! Go to 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
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
Thanks all, I would try those suggestion.
User | Count |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
61 | |
51 | |
51 |