Forum Discussion

ANNING's avatar
ANNING
Icon for Helper I rankHelper I
6 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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 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. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ANNING 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou