Dynamic Slicer based on another Slicer (return filtered text column)
Hi DAXperts, My model has a 12 months (text) slicer - this slicer should be dynamic based on an option selected on another ("Data Set") slicer. The 12 months are to be used as column titles for a data table. This 12 months would show the first X historical months and the remaining Y "budget" or "forecast" months. However, my model is currently showing both Budget & Forecast months. I need it to show Budget or Forecast months only based on the ("Data Set") slicer value selected. Please see below image and attached PBIX file. Any suggestions and work arounds much appreciated.
