Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
These periods range from 2018 - 2020 and are denoted as such:
201801, 201802, 201803.....2018011, 201812.....201901, 201902, 201903..........201911, 201912, 202001 etc.
Jan Feb Mar Nov Dec Jan Feb Mar Nov Dec Jan
However, when using the slicer, it's including periods that don't exist. After the year cuts off at 201812 the slicer shows 201813 through to 201899 and 201913 through to 201999.
My question is this; When using the "between" functionality, how do I have the slicer explicetly show the periods ranging from XXXX01 - XXXX12 and not the numbers in between the fiscal periods (XXXX13 - XXXX99)?
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!
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |