Forum Discussion

atjt217's avatar
atjt217
Icon for Helper III rankHelper III
4 years ago
Solved

Pie Chart filter that can be filtered

Hello PBI Wizards, I would like to ask your help please? I'm trying to create Pie chart that after choosing an Organization from that you can use another filter to compare the whole Organization VS ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi atjt217 ,

     

    According to your screenshot, Location and Organization are in two columns. So when you create a measure, they will in two different levels.  As far as I know, Location and Organization should in same level. Here I suggest you to create a new calculated table with Location and Organization in same column to create the Pie chart.

    Table 2 = 
    VAR _TABLE1 = SELECTCOLUMNS('Table',"Selection",'Table'[Organization],"Requests",'Table'[Requests])
    VAR _TABLE2 = SELECTCOLUMNS('Table',"Selection",'Table'[Location],"Requests",'Table'[Requests])
    RETURN
    UNION(_TABLE1,_TABLE2)

    Dim table for slicer:

    DimLocation = VALUES('Table'[Location])
    DimOrganition = VALUES('Table'[Organization])

    Measure:

    Measure = 
    VAR _Location = VALUES(DimLocation[Location])
    VAR _Organition = VALUES(DimOrganition[Organization])
    RETURN
    IF(MAX('Table 2'[Selection]) IN _Location || MAX('Table 2'[Selection]) IN _Organition, CALCULATE(SUM('Table 2'[Requests])))

    Result is as below.

     

    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.