Forum Discussion
Basil2023
3 years agoNew Member
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....
- Anonymous3 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.
RemyO
3 years agoResolver I
Cant you union the 3 tables into in 1 table ?