Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have created a Year-over-Year (YoY) variance report by month and would like to enhance it with the following features:
Table =
Client IDOrder DateItem NumberClient NameClient Request TypeUnits
150002 | 9/1/2024 | ORT123 | ToysRUs Corporation | Add | 1 |
140001 | 9/21/2024 | ABD123 | Amazon ABC LLC | Add | 1 |
140001 | 9/22/2024 | ABC124 | Amazon XNY LLC | Add | 1 |
150002 | 7/1/2024 | ORT123 | ToysRUs Corporation | Add | 1 |
140001 | 7/21/2024 | ABD123 | Amazon ABC LLC | Add | 1 |
140001 | 7/22/2024 | ABC124 | Amazon XNY LLC | Add | 1 |
150002 | 8/1/2024 | ORT123 | ToysRUs Corporation | Add | 1 |
150002 | 9/1/2023 | ORT123 | ToysRUs Corporation | Add | 1 |
140001 | 9/21/2023 | ABD123 | Amazon ABC LLC | Add | 1 |
140001 | 9/22/2023 | ABC124 | Amazon XNY LLC | Add | 1 |
150002 | 7/1/2023 | ORT123 | ToysRUs Corporation | Add | 1 |
140001 | 7/21/2023 | ABD123 | Amazon ABC LLC | Add | 1 |
140001 | 7/22/2023 | ABC124 | Amazon XNY LLC | Add | 1 |
150002 | 8/1/2023 | ORT123 | ToysRUs Corporation | Add | 1 |
140001 | 8/21/2023 | ABD123 | Amazon ABC LLC | Add | 1 |
140001 | 8/22/2023 | ABC124 | Amazon XNY LLC | Add | 1 |
150002 | 8/1/2023 | ORT123 | ToysRUs Corporation | Add | 1 |
170003 | 9/1/2024 | AOL123 | Ross Inc | Cancel Order | 1 |
180005 | 9/6/2024 | PAS123 | T-Mobile NJ LLC | Cancel Order | 1 |
180005 | 9/6/2024 | PAS124 | T-Mobile NY LLC | Cancel Order | 1 |
170003 | 7/1/2024 | AOL123 | Ross Inc | Cancel Order | 1 |
180005 | 7/6/2024 | PAS123 | T-Mobile NJ LLC | Cancel Order | 1 |
180005 | 7/6/2024 | PAS124 | T-Mobile NY LLC | Cancel Order | 1 |
170003 | 9/1/2023 | AOL123 | Ross Inc | Cancel Order | 1 |
180005 | 9/6/2023 | PAS123 | T-Mobile NJ LLC | Cancel Order | 1 |
180005 | 9/6/2023 | PAS124 | T-Mobile NY LLC | Cancel Order | 1 |
170003 | 7/1/2023 | AOL123 | Ross Inc | Cancel Order | 1 |
180005 | 7/6/2023 | PAS123 | T-Mobile NJ LLC | Cancel Order | 1 |
180005 | 7/6/2023 | PAS124 | T-Mobile NY LLC | Cancel Order | 1 |
170003 | 8/1/2023 | AOL123 | Ross Inc | Cancel Order | 1 |
180005 | 8/6/2023 | PAS123 | T-Mobile NJ LLC | Cancel Order | 1 |
180005 | 8/6/2023 | PAS124 | T-Mobile NY LLC | Cancel Order | 1 |
222222 | 9/21/2024 | 68562A | Target | Create Order | 1 |
212121 | 9/22/2024 | 74432B | Macys | Create Order | 1 |
222222 | 7/21/2024 | 68562A | Target | Create Order | 1 |
212121 | 7/22/2024 | 74432B | Macys | Create Order | 1 |
202020 | 8/26/2024 | 53620A | Lowes | Create Order | 1 |
202020 | 8/27/2024 | 40058F | Home Depot | Create Order | 1 |
222222 | 8/21/2024 | 68562A | Target | Create Order | 1 |
212121 | 8/22/2024 | 74432B | Macys | Create Order | 1 |
202020 | 8/26/2024 | 53620A | Lowes | Create Order | 1 |
202020 | 8/27/2024 | 40058F | Home Depot | Create Order | 1 |
222222 | 9/21/2023 | 68562A | Target | Create Order | 1 |
212121 | 9/22/2023 | 74432B | Macys | Create Order | 1 |
222222 | 7/21/2023 | 68562A | Target | Create Order | 1 |
212121 | 7/22/2023 | 74432B | Macys | Create Order | 1 |
222222 | 8/21/2023 | 68562A | Target | Create Order | 1 |
212121 | 8/22/2023 | 74432B | Macys | Create Order | 1 |
202020 | 8/26/2023 | 53620A | Lowes | Create Order | 1 |
202020 | 8/27/2023 | 40058F | Home Depot | Create Order | 1 |
222222 | 8/21/2023 | 68562A | Target | Create Order | 1 |
212121 | 8/22/2023 | 74432B | Macys | Create Order | 1 |
202020 | 8/26/2023 | 53620A | Lowes | Create Order | 1 |
202020 | 8/27/2023 | 40058F | Home Depot | Create Order | 1 |
150002 | 8/1/2024 | ORT123 | ToysRUs Corporation | Late Fee | 1 |
140001 | 8/21/2024 | ABD123 | Amazon ABC LLC | Late Fee | 1 |
140001 | 8/22/2024 | ABC124 | Amazon XNY LLC | Late Fee | 1 |
150002 | 8/1/2024 | ORT123 | ToysRUs Corporation | Late Fee | 1 |
140001 | 8/22/2024 | ABC124 | Amazon XNY LLC | Late Fee | 1 |
180005 | 8/6/2024 | PAS123 | T-Mobile NJ LLC | Late Fee | 1 |
180005 | 8/6/2024 | PAS124 | T-Mobile NY LLC | Late Fee | 1 |
150002 | 8/1/2023 | ORT123 | ToysRUs Corporation | Late Fee | 1 |
140001 | 8/21/2023 | ABD123 | Amazon ABC LLC | Late Fee | 1 |
140001 | 8/22/2023 | ABC124 | Amazon XNY LLC | Late Fee | 1 |
150002 | 8/1/2023 | ORT123 | ToysRUs Corporation | Late Fee | 1 |
140001 | 8/22/2023 | ABC124 | Amazon XNY LLC | Late Fee | 1 |
180005 | 8/6/2023 | PAS123 | T-Mobile NJ LLC | Late Fee | 1 |
180005 | 8/6/2023 | PAS124 | T-Mobile NY LLC | Late Fee | 1 |
170003 | 8/1/2024 | AOL123 | Ross Inc | Modify | 1 |
180005 | 8/6/2024 | PAS123 | T-Mobile NJ LLC | Modify | 1 |
180005 | 8/6/2024 | PAS124 | T-Mobile NY LLC | Modify | 1 |
150002 | 8/1/2024 | ORT123 | ToysRUs Corporation | Modify | 1 |
140001 | 8/21/2024 | ABD123 | Amazon ABC LLC | Modify | 1 |
140001 | 8/22/2024 | ABC124 | Amazon XNY LLC | Modify | 1 |
170003 | 8/1/2023 | AOL123 | Ross Inc | Modify | 1 |
180005 | 8/6/2023 | PAS123 | T-Mobile NJ LLC | Modify | 1 |
180005 | 8/6/2023 | PAS124 | T-Mobile NY LLC | Modify | 1 |
150002 | 8/1/2023 | ORT123 | ToysRUs Corporation | Modify | 1 |
140001 | 8/21/2023 | ABD123 | Amazon ABC LLC | Modify | 1 |
140001 | 8/22/2023 | ABC124 | Amazon XNY LLC | Modify | 1 |
Dynamic column header measure
I would appriciate any guidance !
Thanks,
RP
Hi @danextian
Thanks for the guidance I was able to get the dynamic header work but the column total is blank now, can you please check the PBI matrix and suggest solution how to fix it?
I am also getting additional column Total which I want to remove.
Thanks in advanced !
Are these measures addedd directly to the matrix or from a disconnected table column being referenced by a conditional measure?
Proud to be a Super User!
Hi @danextian
The measure named 'MyMeasure' was created under CustomPeriod and added to a matrix under Values. This matrix can be found on the third page of the pbix file. I attempted to use dynamic fields, but it didn't work, as shown on the second page. I hope this clarifies things. Apologies for any confusion.
hi @RP101
Not impossible but quite tricky. Please see sample files to help you get started with.
Proud to be a Super User!
Hi @danextian
Thanks for the quick reply ! I will check and see if it helps. how were you able to upload pibx files I was trying wanted to upload mine but didn't see any options.
Only superusers, CST and community admins can. You may post a link to files stored in the cloud though - just make sure they're publicly accessible/no need to request for permission.
Proud to be a Super User!
Hi @danextian
It did not slove my problem completly as I am not getting the column built in grand total. I didn't except that to be not working.
do you have any idea?
thanks
Hi @RP101 ,
You could check the DAX formula used for the dynamic headers and ensure it is designed to aggregate correctly at the grand total level. Additionally, consider using the HASONEVALUE function to conditionally calculate totals when all values are present.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |