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.
I have 2 tables
Table 1 : vehicledata
vehicle_number invoice amount date
Tabel 2 : calendardate
date month year quarter fyquarter monthnumber
I have created one slicer for the year from calenderdate.
My query is when no slicer year selected (means all years data), I need chart axis as year wise.
and if any one year is selected in slicer, i need chart axis as month wise.
Solved! Go to Solution.
AFAIK this it not currently supported in the product.
One possible way to solve this would be to use buttons for the years instead of a slicer.
Then create two visuals - one with year on the axis and one with month.
Then create multiple bookmarks - one that only shows the year chart and others that only show the monthly chart filtered to the particular years and use actions to simulate what you're trying to achieve.
Granted this isn't very scalable as you'd have to keep adding buttons every year but it's the only way I know to implement what you want in Power BI.
You can do what you want in paginated reports if you have access to Premium.
AFAIK this it not currently supported in the product.
One possible way to solve this would be to use buttons for the years instead of a slicer.
Then create two visuals - one with year on the axis and one with month.
Then create multiple bookmarks - one that only shows the year chart and others that only show the monthly chart filtered to the particular years and use actions to simulate what you're trying to achieve.
Granted this isn't very scalable as you'd have to keep adding buttons every year but it's the only way I know to implement what you want in Power BI.
You can do what you want in paginated reports if you have access to Premium.
Hi,
You need to create calculated columns for Year and Month.
- I hope it helps.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |