Forum Discussion
5 Measure bar chart visual filter to a data matrix
JL83 Since you already mentioned that you cannot share the report but I think it will be easier if you create dummy data in a pbix file with the existing measures you have and provide the expected output, it will be easier to provide the solution. From your post, it is very hard to understand the problem and provide a solution. Again, maybe it is me, and probably someone else can provide a solution based on your post. Good luck!
Thanks parry2K.
The problem is I cannot get the matrix table values to filter when I select one of the 5 measures in the bar chart.
I cannot use a DAX created table as it's static (I tried making a table of distinct names). When I tried this the end result was close but using a static table didn't allow the matrix to update when you changed a slicer. i.e. while the matrix value changed from Ford to GM, GM was still showing even though the bar for "Count of Fords" was selected.Let me see what I can do for a dummy data set. The source is 11 columns but I have well over 20 measures for different statisical evaulations, KPIs, etc. I might have another dashboard similar to this that uses a static table for the bar chart and there is no data privacy concerns. Let me see if I can get it cleaned up to represent what I am looking for. I won't have time to get it done until tomorrow, just FYI.. don't sit and wait for it.
