In a bar chart, I want to show the original distribution of data when data are filtered through slicers. I have several filters, and as I select options from these filters, at the moment the bars get filtered as well and only show the relevant bars for the filter. As mentioned in other posts (
https://community.fabric.microsoft.com/t5/Desktop/Showing-totals-and-slicer-selections-in-bar-chart/...), I tried the highlight function which only works with bar charts and not from slicers. The problem with this option is, that I have several slicers with a ‘search’ option, and selecting all the options from the bar chart is not possible, as there are many bars to select. So for example, in this dummy data set (
https://1drv.ms/u/s!AkBkOitEPex_hPVIN0VMQVTL5HZKeg?e=q8mqSd), I want to select all locations with the name ‘Melbourne’. In this example, I have to select both bars Melbourne and Melbourne, Sydney to see the necessary results. Even though I only have two such combinations for Melbourne, if I have around 30 such combinations, some with values close to 0, it is difficult to select all these bars. So is there a way to show the original distribution of the data, along with the filtered results? I tried creating a copy of the data set and creating another set of bars from a different colour. However, I could not get only one data set to be filtered based on the slicer selection and keep the other data set unchanged. Is it possible to achieve this using such a method? Appreciate any possible solutions.
