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 all,
I have a simple bar chart, when I click on a bar, it filters the whole chart. So, I accessed "Data / Drill", clicked on the Data point table option on the menu and it works fine... on all my charts. I save the file, open it again and all my charts are set such that it simply filters the chart, it does not go to the data points table. I can set it again and it's set for the entire session, I save, I reopen and it's back to simply filtering the whole chart.
What am I doing wrong?? Have I missed a setting? I've rebulit it several times, still unable to make it persist.
Any and all suggestions welcome. This tool makes me feel like a dumb-dumb
please share some screenshots of the problem, it is difficult to understand what you are doing exactly.
Proud to be a Super User!
Hi vanessa, thanks for replying so quickly.
OMG I'm so sorry, I posted the wrong image... it took me until yesterday to figure that out so please disregard my last image and please consider this one. It's simply that when I set up a chart and change the Data/Drill section to Data Point Table. It works. I save stuff it still works. I quit Power BI, reopen the report and that setting (Data Point Table) is not active and the chart goes back to simply filtering itself and other charts on the page (the default behavior). I was wondering why that setting doesn't "stick" beyond the session. Please look at the new image I'm posting.
you have marked this as a solution was that your intention? i assuming this isn't resolved?
Proud to be a Super User!
Hey Vanessa, sorry for the delay. I've edited my previous response with the correct image, please take a look. Thanks for your patience.
OMG I'm so sorry, I posted the wrong image... it took me until yesterday to figure that out so please disregard my last image and please consider this one. It's simply that when I set up a chart and change the Data/Drill section to Data Point Table. It works. I save stuff it still works. I quit Power BI, reopen the report and that setting (Data Point Table) is not active and the chart goes back to simply filtering itself and other charts on the page (the default behavior). I was wondering why that setting doesn't "stick" beyond the session. Please look at the new image I'm posting. .. well I'm going to try after I hit the Reply button, I'm not seeing the link just now.
Well it isn't a solution per se, it's a work-around. I will unmark it as a solution since it isn't one really, just a work around. thanks.