Forum Discussion

ANNING's avatar
ANNING
Icon for Helper I rankHelper I
5 years ago
Solved

PBI present irrelevant information when a visualisation bar is selected

Hi all, I have a question and am wondering if my DAX having problem. Hope you can help. Thanks.   BACKGROUND - I have a table consists of all work item objects (EPIC, Feature, etc.) classified b...
  • Anonymous's avatar
    Anonymous
    5 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.