Remove Columns or hide data from the columns based on the monthly date filter

[Anonymous]

Hi,

I am a new into the power bi. Is it possible to remove columns or hide data from the columns based on the date slicer monthly. I have table contains weekly timesheet records.

TimesheetNumber    | Startdate|         EndDate|         Mon | Tue | Wed | Thu| Fri

1                                  1/28/2019         2/1/2019          8        8       8        8       8

2                                  2/4/2019           2/8/2019          8        8       8        8       8

3                                  2/11/2019         2/15/2019        8        8       8        8       8

4                                  2/18/2019         2/22/2019        8        8       8        8       8

5                                  2/25/2019         3/1/2019          8        8       8        8       8

I have a date monthly slicer if i select February 2/1/2019 - 2/28/2017. I want to exclude the other months days. Could you please advise.

Thanks

Vinoth

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try Unpivot Columns in Query Editor and take a look at this post.

[Anonymous]

Thank you very much.