Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all
I want to be able to change my chart dim from month to a year (be able to view the chart by years or by months).
I have created a dim table for the slicer:
Year | 2010 |
Year | 2011 |
Year | 2012 |
Year | 2013 |
Year | 2014 |
Year | 2015 |
Year | 2016 |
Year | 2017 |
Year | 2018 |
Year | 2019 |
Month | Jan |
Month | Feb |
Month | March |
Month | April |
And so on till December..
Hi @Anonymous ,
Not sure how you have your data setup but since you are making this dimension table to change the axis you need to make a measure for each of your calculations.
When you have two tables that are not related and you use one of them on your visuals to give context (in this case the axis) and the values are from another table you will get the full sum (average, count,...) on the table of the values since there is no relation between axis and values so it pick up everything on the value side.
Based on this create a measure for the calculation of the YEARS / MONTHS and using a switch measure return the value to your chart.
Check this post with an explanation how to achieve this.
I have also authored a post in the community with 3 options to get this made, please also see different possibilities to achieve this.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |