Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Grouping Based on Date Filter then Count

Hello,

 

I have a scenario that i want to apply.

According to the screenshot attached, i have made group on the first 3 columns and get the count of rows.

I want to make grouping on them also based on filter/slicer on visual it "after transformation".

Please, Any help ? 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    The filter and slicer that used on the data view not able to interact with backend query tables.
    BTW, these filter/slicers also not able to affect the data model tables to create dynamic calculated column/tables because they are work on different data levels.

    Notice: the data level of power bi.
    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