Dear community,
I've run into a problem that I can't solve.
I'm creating a PBI-report for a employer survey.
On the top there are different slicers for departments, areas, offices, titles etc where I using a measure couting the number of answers (rows) and if there are 4 or less answers the slicers and visualizations are blank hence there need to be a minimum of five answers for the result to be shown.
- Each question has has it's own visualization and every question is graded 1 to 5.
- I want to have the results from different years next to each other in the same visualization.
When only having data from one year (2023) it was no problem but when adding data from 2024 the problem occurs.
My measure on the slicers is set to year=2024 which is good.
But I cannot limit the results in my stacked bar vizualisations. I have created a measure that counts the number of answers depending on the filter & question and the output is a number.
When I use that measure on my visualization with the condition =>5 it treats the different options as one answers so when I set the minimum to 5 it hides all the options that have less then 5 answers. There can be different combinations of answers but I want it to look at the total number of answers.
Does anyone know how I can get my visualization to understand that it needs a total of 5 answers on a question from 2023 to show the bar for 2023 and at the same time have the same logic for 2024. It has four outcomes. Show none, show both, show 2023 and show 2024.
Pls let me know if I should clarify something and thanks in advance for any idea that can help me solve the problem.
//Christoffer
