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

Thats the thing i wanted, but im having trouble with the step 5. The column you described at the step 5 is always false. Probably i did one of the previous steps wrong, but the measure of the steps 3 and 4 with its respective value seems okay, their values update in real time when i choose one or other option in the slicer. 

 

d_m_LNK's avatar
d_m_LNK
Super User
6 months ago

Make sure that the correct comparisons are happening for the correct table.  Also I think I forgot something in the last measure:
MeetsCriteria =
SWITCH(TRUE(),
SelectedValue(Table[Fecha]) > [AddMonthToSelected] && SelectedValue(Table[Vencimiento])< [AddMonthToSelected],
1, 0
)