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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-henryk-mstf,

 

thank you for your answer. I think I found the issue.

I had some errors and no data in table, after replacing the errors with a 0 I got the correct values.

 

Maybe you have some advice for me, how to replace the errors and cells without data, to get a correct unpivot table.

 

Thank you and best regards,

 

Albert