Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a table with a date column and I would like the user to be able to select fiscal year's start month. Based on the user filter selection, the table (which includes the dates) would assign the appropriate fiscal years.
For example, a table with dates and counts:
Date | Count |
1/1/2021 | 4 |
2/15/2021 | 5 |
3/20/2021 | 6 |
4/1/2021 | 2 |
5/10/2021 | 4 |
6/30/2021 | 5 |
And a table of months index, used as the filter:
Month Index |
1 |
2 |
3 |
4 |
5 |
... |
If the user filtered on "1" (January), then that would indicate a normal calendar year and all the rows in the above example would belong to year = 2021. If the user selected "3" (March), indicating they wanted the fiscal year to begin March 1, then the first two rows in the above example should be assigned year = 2020 and all other rows would be year = 2021.
Ultimately, I would like a bar chart that adjusts with the users selection and has year on the x-axis and count on the y-axis. Can this be done?
Hello ,
is it possible to share some data sample ? ,
to create a dynamic measure you should do the following for the fiscal year :
1 : create a column in the table you have with this measure :
if(month(table[date])<[star month],year(table1[date])-1,year(table1[date])) +
if(moht(table1[date])>=[start month],1,0)
//////
then to have this work make a parameters in the modeling tab :
new parameter : as per the image attached :
Nem : Start Month , Type whole Number , Min 1 , MAX 12 , leave it as default ( 1 ) as for January .
Then , when bar chart is created you can youse fiscal year calculated column as the x axis and the count column as the y axis , the user can adjust the start month and the chart will be updated dynamiclly bas on the selection .
Kindly accept as a solution if it works with you and a kudo would be appreciated .
Regards ,
I can't make a column dynamic and respond to a changing parameter. The column stays fixed at the parameter default value. Am I missing something?
See below. As it is, the data plots like the upper-right chart. When the slicer is at 3, I want the chart to look like the lower-right chart. How can I make a dynamic chart that does this?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |