Forum Discussion
Dynamic Forecast Year
Hi guys, I have a Stacked Column Chart with Spend vs Fiscal Year data. The Total Amount columns are broken down into Category values. How do I make it so that only the 5 Fiscal Year...
Hi Stuznet,
One sample for your reference.
1. Create a calculated table.
Table = GENERATESERIES(1899,2100,1)
2. Create a measure as below.
Measure = var y = SELECTEDVALUE('Table'[Year])
return
IF(MAX(Table1[year])>=y && MAX(Table1[year])<=y+5,1,0)
3. Create the Stacked Column Chart and add the measure to tooltip and make the visual filterd by the measure.
For more details, please check the pbix as attached.
Regards,
Frank
v-frfei-msftThank you for providing your solution however it doesn't seem to work for me. I followed what you did but I'm getting false result
Hi Stuznet,
Could you please share your pbix to me? You can upload the file to dropbox and share the line here.
Regards,
Frank
