Forum Discussion
YoY Variance Report by Month with dynamic header
Hi, I have created a Year-over-Year (YoY) variance report by month and would like to enhance it with the following features: Add a dynamic header when a year is selected. I tried creating dynam...
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?
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.
