Forum Discussion
Filter two columns in a table visual
I have a customer_data table with 3 columns: customer, sales and date.
I would like to have a table visualization with the customer sales from week X and week Y filtered by date slicer.
For date slicer I've created calendar table and successfully created a relationship between them.
End product (+ filter to choose weeks)
| Sales | Week X | Week Y |
| John | 2 | 123 |
| Jessie | 30 | 6578 |
| Michael | 451 | 1203 |
1 Reply
Hi jcollier,
From your description, if I understand your requirement correctly, do you want to have the output below?
If it is, your steps described above should be right. You also could have a reference of my test file.
If it is not, could you share a dummy pbix file and your expected output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
