Forum Discussion
Table visual object filtering another table visual object by selecting a value from
Damian_CT_Nom ,
From Power Query Editor, Unpivot your table to bring in ticket type categorical field and No. of tickets numeric field.
Please share the .pbix file here if possible so that we can make changes in it and share back.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
Thanks for your answer Anand24 but as you can see, the "Closed Tickets" column is also in the table to the right. It won't filter by the closed tickets for week 12 even if I click on the "2" in the left.
Damian_CT_Nom ,
When you click on "2", Power BI still filters on categorical values in table. So in your case, even if you click on "2", it filters for what that 2 value is against, i.e., week = 23cw12.
You will need to add a categorical field for ticket type in the left table visualization.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
I don't actually know how to do that... I've switched from table to matrix using the weeks as rows and puting the sum of closed, closed by system and reopened as values. But same thing happens. Could you please tell me how to achieve this?
Damian_CT_Nom ,
From Power Query Editor, Unpivot your table to bring in ticket type categorical field and No. of tickets numeric field.
Please share the .pbix file here if possible so that we can make changes in it and share back.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedInThank you Anand24 this worked for me now!