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 Experts
I have a requirement where a slicer selection need to change the dimension used in bar graph.
I have a year slicer, if I select only one year then bar graph need to show data for months in that year and if more than one year is selected in slicer then bar graph need to show data for year, Here graph need transition between two dimensions Month and Year.
Tried using HasOneValue, SelectedValue but with no success.
Any idea would be highly appretiated.
Thanks
Solved! Go to Solution.
One way of doing thing simplistically is, create a date table, with year, month column.
and then add year and month on x-axis of bar chart. At first, chart will show yearly data, so if multiple years selected in date slicer, you should be able to see all data at year level.
If only one year is selected, you just need to activate 'Drill mode' on on the chart and click the bar, it will automatically transit to month level.
One way of doing thing simplistically is, create a date table, with year, month column.
and then add year and month on x-axis of bar chart. At first, chart will show yearly data, so if multiple years selected in date slicer, you should be able to see all data at year level.
If only one year is selected, you just need to activate 'Drill mode' on on the chart and click the bar, it will automatically transit to month level.
Thanks for the reply, I am looking for the way to do it withoout user intervention, I mean not using drilldown option.
Can you please help me.
Hi, @askkumar
Power BI doesn't supported it currently.
It is suggested to post your idea on Power BI Ideas.
What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Community Support Team _ Eason
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |