Forum Discussion

Basil2023's avatar
Basil2023
New Member
3 years ago
Solved

KPI Donut Chart

Hi There,    Im new to PowerBI and looking for some help with PayPal KPI Donut Chart.  I am trying to link multiple tables of the same field into the KPI Donut Chart and then filter by Year slicer....
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Basil2023 ,

    Please try below steps:

    1. below is my test table

    Table:

    Table1:

    Table2:

    Table3:

    Model:

     

    2. create a measure with below dax formula

    Measure =
    VAR target = 80
    VAR cur_year =
        SELECTEDVALUE ( 'Table'[Year] )
    VAR tmp =
        UNION ( Table1, Table2, Table3 )
    VAR tmp1 =
        FILTER ( tmp, [Year] = cur_year )
    VAR _val =
        SUMX ( tmp1, [Sale] )
    RETURN
        DIVIDE ( _val, target )
    

    3. add a  visual with this measure and add a slicer with "Table[Year]" field

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.