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 all,
I am hoping someone could suggest me a way to add a monthly total(i.e. 75000/month) for Fiscal Year 4 on a clustered column chart.
I have a table with a date cloumn, with data from [October 2015 to October 2017]. Currently, I have the chart with two Fiscal years with total number of tokens used/month comparing Fiscal Year 2 & Fiscal Year 3 (i.e. years: from 27-oct-15 to 26-oct-2016 & from 27-oct-16 to 26- oct- 2017)
Now, I would like to add a value representing Fiscal year 4.i.e. (from 27-oct-2017- 26-oct-2018) with a monthly value of 75000 tokes used/month on the same chart. How would I be able to do this?
Here is the Table structure:
Chart:
Axis parameters used for the chart:
Any help would be very much appreciated.
Thank you!!!!!!!!!!!
Solved! Go to Solution.
Hi @Rck7,
If your value is a fixed value then just add a measure with that value in your case:
Fiscal/Year 4 = 75000
Then add it to your chart:
In the example the the October, November and December don't appear on PY and CY becaus I have values YTD.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Rck7,
If your value is a fixed value then just add a measure with that value in your case:
Fiscal/Year 4 = 75000
Then add it to your chart:
In the example the the October, November and December don't appear on PY and CY becaus I have values YTD.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |