No respect filter when use table constructor with DAX

[Anonymous]

No respect filter when use table constructor with DAX

I have a table with values ​​distributed in columns, but I need to calculate on the graph as if it were the same axis.

When select period filter of dates, must show only values ​​corresponding with select dates.

In table the first column is Date, second column is Vendor and de last column is Customer Satisfaction Survey.

Link for file

https://we.tl/t-e8us4WyiHL

[stevedep]

Hi,

You need to unpivot the data first:

File is available here.

Kind regards, steve.

ps. please mark as solution when this is what you are looking for. 

[Anonymous]

Thanks Steve, but i need filter CSAT for Vendor.

In the solution you passed, it will be necessary to add a column of dates, but in this case it is necessary to make a table with all the necessary information.

I would like to execute all of these instructions in DAX.

[stevedep · Accepted solution]

Hi,

its possible to retain the vendor column so you can filter. 

[Anonymous]

Sorry. Steve, now i understand the solution. For application of the solution is necessary turn columns into rows.

I searched other ways, for not turn columns into rows. But thanks for solution, and i go implement in the my project.