Forum Discussion

Atlan's avatar
Atlan
Frequent Visitor
2 years ago

Problem with Slicer and Advance Card

Hi, I have a problem with my dashboard. I use the preselectet Slicer for my dashbord to filter a value for a advance card. This works. The Card show the value for the current month. I can use the ...
Need Help
Atlan's avatar
Atlan
Frequent Visitor
2 years ago

HI Xiaoxin,

 

sorry but this unfortunately doestn't help me. I tried some other things. It won't work.

Here some pics:

 

 

The Preselection Slicer filters the month but the Card is empty or shows the same value like current month.

Do you have any idea?

 

Thanks and Best Regards.

Atlan

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Atlan,

    Have you tried to use date function to get the previous date? AFAIK, dateadd function may not so suitable for filter table records.

    Time Intelligence "The Hard Way" (TITHW) 

    BTW, current power bi does not support to create dynamic calculated column/table based filter effects. They do not work on the same level, and you can't use child level of effect its parent.

    Notice: the data level of power bi(from parent to child level)

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng