Forum Discussion
Month/Week filter on the chart
Hello everyone,
I wanted to ask for your help, as I'm facing a doubt/problem. I would like to filter the last month in a chart I have, showing all the weeks of the last month. However, I would like that when I filter more than 1 month, all the weeks of these month(s) appear to me. I tried using the 'TOP N' filtering, but it doesn't allow that, it only filters by 1 month even if I select more than 1. I wanted to know if it's possible to do this type of filtering in a chart?
Thank you in advance for your help.
1 Reply
Hi Lwpro
Which kind of chart are you using? Do you add both month and week columns to the chart? If you are creating a weekly line chart or column chart, the following links should be helpful. You don't have to use the Top N filter, a common list or dropdown slicer should work.
Weekly Data with Monthly X-Axis with a Line and Clustered Column Chart
Improving timeline charts in Power BI with DAX - SQLBI
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
