Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Use Column headers as slicer

Hello to all,   I am new here and was wondering if someone could help me.   I have a table in Excel, that looks like the screenshot below. The table has more than 4000 rows. I would like t...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    I did a test, you can use unpivot column only for the month column in powrbi query, and then filter out the data corresponding to the month.


    If the problem is still not resolved, can you provide a test data model (delete sensitive information) so that I can answer it for you as soon as possible. Looking forward to your reply.

    Best Regards,
    Henry

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

ERD's avatar
ERD
Community Champion
5 years ago

Hi Anonymous ,

You need to choose all month-related columns (JAN - DEZ) and then Unpivot them. Your sum (Gesamtergebnis) will be counted in the report (by a measure or implicitly). 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ERD.

 

unfortunately it shows me still the wrong values.  There are no formulas in the table, so this can also be excepted.