The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi there,
I have a page with 4 different visualizations. Three are bar charts and one is a pie chart.
The data from the pie chart is a Switch DAX and the bar chart data is a count with data merged from two other tables.
The stakeholder is looking to be able to filter the data by clicking on the columns in the three bar charts. The yellow represents customers with no account of that type, and the blue represents customers who do have that account type. Right now, I am only able to filter if I click on the pie chart. The other three visuals will change.
However, if I click on any of the 6 columns, nothing filters or changes. I have set the edit interactions for each bar chart to highlight so in theory they should all filter when selected. What am I doing wrong?
Thank you!
Hi @KW123 ,
These might be relationship issues between the tables as they might have not connected properly if data is comming from different table
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem
Regards
There are a total of 3 tables being used. Two tables are merged together via a left join to the main table and I am using the merged data all off the main table. Is it still possible that is the issue? If so, how would I fix that?
I just built a fake table and added in some dummy data to see if the issue is the merge or not. Even when I build the visuals from the 1 fake table, it is still not allowing me to click on the columns to further filter the data. I am only able to select the different transaction bands to filter the columns on the bar charts.
Thank you!