Change columns using filter

[Anonymous]

Hi, 

I am developing a matrix which shows the worked hours of the employees.

I need to have a vision by Year, Month, Day and so, I put this options on a filter and I need the columns to change in accordance with the filters, showing the values respectively.

Is there a way to do this?

I changed the columns manually to help you understand what I need.

OBS: I know I can do this using drill-down, but I need to do this with the filter

 YEARDAYMONTH

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my research, I am afraid you could not achieve this feature currently, I suggest you refer below link that may give you a work around:

http://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Regards,

Daniel He

[Anonymous]

Hi @v-danhe-msft, 

I tried this solution and it solved my problem.

Thank you for your time and disposition to help.

Best regards