Forum Discussion
Using dates for filtering grouped table
Hey,
maybe i'm missing some important fact, but why just create a slicer from the columns, whatever you select in the slicer filters / groups the rows in your table.
Maybe you also might consider to create a separate date table and use relationshops in you data model.
Hopefully this is what you are looking for and I'm not overlooking the obvious
Regards
Tom
Hi Tom, thanks for the reply. Maybe I'm missing something, but when I create a slicer on the raw data, and apply a filter (let's say February), the data that will be displayed are all the rows and not filtered. That is why I built the grouped info as shown below, but when I did that I lost the date field
Any help will be great
Ezequiel
Hm,
what I described above is basically the magic of Power BI, besides some ohter things :-)
Can you provide a screenshot from the "Relationships" pane something similar like this
or better provide sample data?
Regards
Tom
Sure!. This is the sample of the data. I need to chow the info summarize by Category and subcategory whoing the revenue and being able to filter it by the month the case was created. Let me know if this is clear.
Case Number Proactive or Reactive Status Reason Category Sub Category Created On Revenue Case 1 Reactive Closed (Resolved) Category1 Subcategory1 29/03/2018 18:15 $ 450.000,00 Case 2 Reactive Closed (Resolved) Category2 Subcategory2 29/03/2018 14:40 $ 550.000,00 Case 3 Reactive Closed (Resolved) Category3 Subcategory4 27/03/2018 16:10 $ 312.000,00 Case 4 Reactive Closed (Resolved) Category3 Subcategory4 26/03/2018 16:09 $ 209.520,00 Case 5 Reactive Closed (Resolved) Category4 Subcategory3 23/03/2018 16:35 $ 468.000,00 Case 6 Reactive Closed (Resolved) Category2 Subcategory2 23/03/2018 9:48 $ 75.000,00
