Forum Discussion

Jan03's avatar
Jan03
Frequent Visitor
6 months ago
Solved

Dynamic Complex Filtering with slicers

Hello, I have a question. I am learning Power BI and I want to implement dynamic filtering based on user interaction within the dashboard. Specifically, I need the user to select a date from a li...
Need Help
  • v-echaithra's avatar
    v-echaithra
    6 months ago

    Hi Jan03, 

    Please find the attached PBIX file below. I hope it meets your requirements.

    Kindly review it and let me know if you need any further adjustments or clarifications. If the issue still persist please share a sample PBIX file with sample output.

    Thank you.

Jan03's avatar
Jan03
Frequent Visitor
6 months ago

Thanks, but it doesnt work. I did exactly what you said. Probably i made a mistake in the medium steps. And the problem isn't the data.

 

 

d_m_LNK's avatar
d_m_LNK
Super User
6 months ago

I think the only issue is that your initial variable is potentially pointed to the calendar table that has a relationship to the fact table and not the disconnected SlicerDate[Date] table you created for the slicer.

  • Jan03's avatar
    Jan03
    Frequent Visitor
    6 months ago

    I cant see a relationship between tables. The calendar table (which creates the slicer) is apart.