Forum Discussion
Pre-defining x-axis values and filtering visuals
Do you just want the visuals to not interact with one another? Like, if someone clicks on a bar in Years, do you not want the bars in KC to cross highlight? If that is the case, you can turn of interactions between the visuals. If items from the x-axis are disappearing in KC when you click on an item in the viz of Years, but you want them to all still show, for teh KC chart, right click on the item for your x-axis and select Show items with no data.
I do want the visuals to interact with each other.
Try the Show Items with No Data - that will keep the items that don't have a value still showing up.
That would only work if Power BI already knew what the options should be, such as if it were possible to use an array that defined what all the options should be. In the Years question of the original example data, only three of the six options were selected. So even if I do enable ‘show items with no data’, Power BI only knows that 2, 3 and 4 were the options that had been selected. Breaking out this question into its own table resolves the x-axis issue, but then it doesn’t allow you to click on the visual to filter the other visuals.