Forum Discussion
BuckyKat37
Advocate II
2 years agoPre-defining x-axis values and filtering visuals
I need help with how to best model and visualize post-training evaluation data/responses that comes to me as a flat data file. The two things I’m struggling with are: Setting the x-axis of a visual...
audreygerred
Super User
2 years agoTry the Show Items with No Data - that will keep the items that don't have a value still showing up.
BuckyKat37
Advocate II
2 years agoThat 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.