Forum Discussion
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 bas...
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