Forum Discussion
MTD Chart Visual
Hi Anonymous ,
You can use "Enter data" method to create the month dimension table to replace the original one, please find the details in the attachment.
And for the visuals which not effect by the month slicer, you can consider to create measure with the filter (like 'Table'[month]=selectedvalue('Months'[Month])). Anyway, it need to make the proper change base on the actual situation...
Best Regards
Hi Anonymous ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a month dimension table and apply the month field on the slicer
Months = VALUES('Date Table'[Month])
2. Create a measure as below
Measure =
VAR _selmonth =
SELECTEDVALUE ( 'Months'[Month] )
RETURN
SUMX (
FILTER ( 'Date Table', 'Date Table'[Month] <= _selmonth ),
[Data Act/Sales Act]
)3. Create a visual as below screenshot
Best Regards
Hiii 🙂
Thank you very much for providing the solution. However, I have a couple of problems.
Using New Table, I created the Month table according to your example: Months = VALUES('Date Table'[Month]).
The problem arises if, for example, in 2023 we still only have 8 months out of 12. But since, for example, 12 months have already been written in 2022, even with the filter for the year 2023, I see 12 months instead of 8. Is this possible?
And one more problem, the rest of the visualization is not responsive to the Slicer with the Month filter from the Months table. There is probably no other solution, so what you provided is probably the best.
Thank you very much
Hi Anonymous ,
You can use "Enter data" method to create the month dimension table to replace the original one, please find the details in the attachment.
And for the visuals which not effect by the month slicer, you can consider to create measure with the filter (like 'Table'[month]=selectedvalue('Months'[Month])). Anyway, it need to make the proper change base on the actual situation...
Best Regards