Forum Discussion

sshikari's avatar
sshikari
Regular Visitor
8 years ago
Solved

Filtering before group by

I have data that needs to: 1. be filtered by date when pulled from the data source  2. grouped by 4 of the fields    In my visualization, I want the user to be able to pick the date that filteres...
  • sshikari's avatar
    sshikari
    8 years ago
    Thank you for the suggestions. After digging into this further I think my issue was that in power bi I had not grouped the data by the date. I thought that I could use the slicer to filter the data in a previous step (before the grouping) but it seems that the sliver affects the most recent state of the data. Including the date in the group by exposes it in the most recent state and now I can filter. Thanks for your help.
sshikari's avatar
sshikari
Regular Visitor
8 years ago

I have a data set that I need to:

1. filter by date and then

2. group by 4 fields. 

 

I would like to provide a date picker in the visualization that will control the data filtered in step #1.  If I add a date picker right now, it doesn't seem to do anything when I select various dates and I think it is because the date is not one of the 4 grouped by fields.  I think a similar question has been asked: https://stackoverflow.com/questions/48425702/group-rows-after-applying-user-filter-in-power-bi?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa

 

Thanks.

edhans's avatar
edhans
Community Champion
8 years ago

Why not use a Matrix visual to do this?

Put your 4 grouping columns in the "ROWS" of the matrix, the measures you are summarizing in the "VALUES" section, and then a filter visual on the dates. The matrix will automatically exclude data outside of your date range.