Forum Discussion
PBI present irrelevant information when a visualisation bar is selected
- Anonymous5 years ago
Hi ANNING
Your measure use All function in Status column, so your visuals will return to all Status even if you select the Stack column visual(Active). You may try to avoid using all.
IF your Data model is like this you don't need to build measures to achieve your goal.
You can build visuals directly and use count in Values.
And add Status in Filers to filter Active, New or Done for each visual.
Result:
You can download the pbix file from this link: PBI present irrelevant information when a visualisation bar is selected
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ANNING
Your measure use All function in Status column, so your visuals will return to all Status even if you select the Stack column visual(Active). You may try to avoid using all.
IF your Data model is like this you don't need to build measures to achieve your goal.
You can build visuals directly and use count in Values.
And add Status in Filers to filter Active, New or Done for each visual.
Result:
You can download the pbix file from this link: PBI present irrelevant information when a visualisation bar is selected
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.