Forum Discussion

Tomek1982's avatar
Tomek1982
Icon for Helper I rankHelper I
3 years ago

How to sumarize values from selected columns

I have a following slicer and a table:     How to calculate "temp total" based on a slicer selection? Expected result would should follow standard slicer functionality, eg.: - when "a" sel...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Tomek1982 ;

You could unpivot the columns in power query.

1.tranfroms -> unpivot columns 

2. add matrix visual.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Tomek1982's avatar
    Tomek1982
    Icon for Helper I rankHelper I
    3 years ago

    Hi,

    I already did pivot. The story behind is that I had some missing data. I did pivot to fill the gaps. I do not think I can unpivot this table, or can I?

     

     

    Example PBIX 

     

    I would like to chooose variables in the lower graph by slicer