Forum Discussion
Showing data weekly or monthly dynamically
I have sales data with SaleDate column. Now I'd like to have one drop down selector (filter) with options "Monthly" and "Weekly" where one will be able to select wether this sales data will be repres...
Hi there Anonymous
Now that field parameters are available, I would recommend using that feature as a means of changing the field used on the axis.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Using field parameters avoids the modelling used in the post you linked to (wow, that was 7 years ago!).
Please post back if more guidance needed.
Regards
Yea, OP was posted several years ago but, you see, you're still here to help. That's wow, as well. 🙂
Thanks for your prompt response. It seems that field parametera are exactly what I need.
Seems that Microsoft concluded too that people will need this feature.