Forum Discussion
Solved
Dynamic Filtering of X-Axis
Hey there, I'm looking to dynamically filter my visual with two slicers. One slicer is tied to an unrelated Date table to get access to all of the Month Year Date values in the data. The other sl...
Hi ryanbott ,
Please refer to the blog.
Display Last N Months & Selected Month using Single Date Dimension in Power BI
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ashish_Mathur , unfortunately, I only have Excel for Mac and I'm unable to inspect your Excel solution to see if I can apply it in PowerBI.
- Ashish_Mathur
Super User
Hi,
Download my MS Excel file and do not open it. Open PowerBI Desktop and go to File > Import > Power Query, Power Pivot and Power View. This will import all my work from the Excel file to the PBI Deskto file. Thereafter, you will still have to open my Excel workbook to see which columns have to be dragged to which visual.
