Forum Discussion

me1982's avatar
me1982
Frequent Visitor
2 years ago
Solved

Adding a MISSING value to a pie chart

In powerBI I have a table of elements and a table of properties (key and value for each propery) . Properties are linked to elements using an element ID. Not all elements have all the properties. ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi me1982 ,

     

    As you said, measure cannot be applied to pie charts. try the following calculated column.

    result_ =
VAR elementID = Elements[ElementID]
VAR shirtSize =
    CALCULATE (
        MAX ( 'Properties'[Value] ),
        'Properties'[Key] = "Shirt Size"
            && 'Properties'[ElementID] = elementID
    )
RETURN
    IF ( ISBLANK ( shirtSize ), "Missing", shirtSize )

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

I would like to help but I'm a little unclear about your requirements.

 

Can you show the following?

 

1)  Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

 

2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

3) Please explain how you would expect to get from step 1 to 2.

 

4) If possible, please show your past attempts at a solution.

 

I hope this helps.