Forum Discussion

PowerBI_Canuck's avatar
PowerBI_Canuck
Frequent Visitor
5 years ago

Dynamic variable calendar for column chart

In my report I have a calendar slicer set to "Before".               The use case is, users will select the "to date" of the slicer and the report will display data relative to the sele...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

PowerBI_Canuck  I don't fully understand your scenario yet as the Ei 1 and Ei 2 examples you have provided have a date selected in the middle of the range provided. What do you want your date table to look like in the end? 

 

I prefer to create the Date table in Power Query. Then you can add a conditional column for the ERP start and end dates, and use those in your slicer if I'm understanding your problem correctly? 

 

https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html