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.
Hi,
I have downloaded the timeline slicer from the visual gallery.
However, I find I can't seem to map the fiscal year correctly using the settings. I have data from Oct 2013 till Sept 2016.
My fiscal year starts on Oct 1 2013 as FY14.. however, the slicer recognises it as start of FY13.
How does one resolve this so that the fiscal year is mapped correctly on the slicer?
Solved! Go to Solution.
@Anonymous
Please try to create another date column by adding one year and drag this column into timeline visual.
Date_New = DATE ( YEAR ( Table1[Date] ) + 1, MONTH ( Table1[Date] ), DAY ( Table1[Date] ) )
Best Regards,
Herbert
@Anonymous
Please try to create another date column by adding one year and drag this column into timeline visual.
Date_New = DATE ( YEAR ( Table1[Date] ) + 1, MONTH ( Table1[Date] ), DAY ( Table1[Date] ) )
Best Regards,
Herbert
Hi,
Does anyone know how to make the Visual: "Timeline.1.3.17" from Power BI Visuals Gallery... map to Microsoft's fiscal year calendar? Thank you!
Hi Ashish,
You can use newly added Date slicers update in the Oct Update. This will manually allow you to configure your date slicers.
Refer to this VIDEO.
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |