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.

v-echaithra's avatar
v-echaithra
Community Support
6 months ago

Hi Jan03 ,

Right now your slicer table is correctly disconnected, but your row-level measure is being evaluated in an aggregated context, so MIN() or SELECTEDVALUE() isn’t reliably pulling the current row’s Fecha/Vencimiento. That’s why it always returns false.

Try again with this measure:


InRange =
VAR SelDate = SELECTEDVALUE ( SlicerDate[Date] )

VAR SelPlus1 =
EDATE ( SelDate, 1 )

VAR RowVenc =
SELECTEDVALUE ( Fact[Vencimiento] )

VAR RowFecha =
SELECTEDVALUE ( Fact[Fecha] )

RETURN
IF (
NOT ISBLANK ( SelDate ) &&
NOT ISBLANK ( RowVenc ) &&
NOT ISBLANK ( RowFecha ) &&
SelPlus1 >= RowVenc &&
SelPlus1 < RowFecha,
1, 0)

For each visual you want filtered drag InRange into Visual-level filters and set it to is 1.

Hope this helps.
Thank you.

Jan03's avatar
Jan03
Frequent Visitor
6 months ago

It doesn't work, but I appreciate your time. The measure is always 0, but like i said before, the problem isnt the data because when i apply filters in each object like the image, it works.