Forum Discussion
Solved
Table visual object filtering another table visual object by selecting a value from
I'm struggling to find a solution in google because "table" goes also for the data table. Is there a way to filter one table by another just by pressing a value? As you can see inthe a...
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
Hi Damian_CT_Nom ,
Power BI visuals in itself filter one another when you click on elements. Now the thing is that this filtering is done for the categorical/dimensional data.
In your scenario, when you click on week in left table, it filters right table only for week = 23cw12 and not for week = 23cw12 AND type=Closed.
Hence you can add type (closed, closed by system, reopened) into rows instead columns in left chart or add type in right chart.
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 !!! |