Forum Discussion
"Current year" as default value for year slicer hack?
I know this is not supported yet™ but I'd like to ask if someone knows any workaround... I've thought about a couple of things: Having every value displayed in the report as a measure like t...
Hi ThunderRoad,
You may need to create an addtional calculate column to achieve current year and then use that column to filter the chart, similar case for your reference: https://community.powerbi.com/t5/Service/Default-value-in-Report-Filter-Panel/td-p/47574.
Regards,
Jimmy Tao
Hello,
You can select the current year in the slicer and save,publish the report, which acts as default value.
The user will have the ability to filter other years if they want to.
If you have any other calculations to be performed based on the selection. You can use the "SELECTEDVALUE" function in the measure which brings the Current year(in dafulat case)/the user selected value in all other cases.
Hope this helps.
Let me know if you have any questions.
Thanks,
Soumya