Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I am trying to hide the columns in Matix for all months except the last two months.
Please see below the screenshot where I wanna hide only the puple color colums and keep the green color column which is having calculated data for Last two months.
Please help,
Thanks.
As @v-chuncz-msft there is no such provision in Power BI.
Couple of things to check with you.
The image you have posted has two values for each month being displayed.
Is your requirement - cost to be displayed for all months and the difference is to be displayed for last two months ??
Or you want both the cost and the difference to be displayed for last two months ?
WHen you say last two months what is the rule to be applied is it last two months from current month ? or will you be using a slicer to select a month and the output should be for last two months from the selected month.
Cheers
CheenuSing
Hi CheenuSing,
Thanks much for your reply.
1. Cost to be displayed for all months and additionally in the last one column added in matrix for displaying the difference for last two months
2. No Slicer. Just want to display the data for all months (2016 and 2017) and once all the monthwise total displayed in matrix then in the end additional one column display the difference between last two month in the matrix.
3. In my provided table - the last two month are July 2017 and August 2017 so the difference column should display the difference in matix categorywise . Please see below the example table for your reference.
Please let me know if you have any questions.
Regards,
Mamoor.
Eqp Typ | Svc Dt | COUNTRY | Cost | Diff. Aug vs. Jul | |
Table | 8/18/2017 | US | 68 | 68 - (243+68) | |
Table | 7/8/2017 | US | 243 | ||
Table | 7/8/2017 | US | 68 | ||
Table | 2/22/2017 | US | 94 | ||
Table | 12/1/2016 | CA | 66 | ||
Table | 11/30/2016 | CA | 268 |
As far as I know, there is no direct way. You may adjust the column width manually.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |