Forum Discussion
Help with Slider Visual; Using "between" function for period dates not working
Hello Power BI Community, Having some trouble with the Slicer visual. I'm using the "between" functionality on it, because i'm trying to have my dashboard reflect data between fiscal periods. Th...
The between slicer needs a continuous column, and will show all numbers in a continuous way between the two values.
There's no real easy way to do this with a between slicer. One way, could be to use the Microsoft custom vis - "Timeline Slicer". You are slicing off a date key, but for this you really want to use a date column, formatted as a date. you can use a calculated column such as:
Date = DATE( LEFT(Table[Fiscal Period],4) , (RIGHT(Table[Fiscal Period],2), 1)
Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!
Stay up to date on
Read my blogs on
Remember to spread knowledge in the community when you can!