Forum Discussion
Need to add multiple measures to Matrix Rows
Hi BIUser0101
Are you trying to merge two matrices while hiding Valid Registrations and Is Late (>09:10:00) and showing only their totals? If I understand correctly, please refer to the following test:
Since I don't have the data from your calendar table, I added a date column to the data to act as a column for the matrix, with the No. column acting as a filter in the test.
Place the cursor at the junction of the corresponding column and drag it to the left until it is hidden.
And turn off Text wrap for column headers.
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yulia,
>Are you trying to merge two matrices while hiding Valid Registrations and Is Late (>09:10:00) and showing only their totals?
Yes that is what I'm trying to do but as I mentioned:>I tried hidding them but every time the segmentation (filters) change, the values appear again
If there is a way to keep only those columns hidden even when I change my filters (like week, months, dates in general) that would solve my problem.
Nonetheless, I appreciate your help.Hi BIUser0101
Based on my test, I'm afraid that Power BI cannot implement this requirement directly. But I think your idea makes sense and I find an idea that has a similar need to yours, you can vote for it to help make it happen as soon as possible. https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=31d0f24a-0194-ee11-a81c-000d3a00bef9
Hopefully this will be possible in a future release.
If you can consider using the method mentioned in my previous reply, and you want the column to no longer appear when you change the filter, you need to hide the column once for each filter option. For example, in my test, I added the date 9/24/2024. When I filtered the data for 9/23/2024, I hid "Is Late". When I selected 9/24/2024, I needed to hide "Is Late" again. After that, if you select the 9/24/2024 option again, the "Is Late" column will no longer appear.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
