Forum Discussion

newbiepb's avatar
newbiepb
New Member
2 years ago

Help to create filter

Hello, friends,

I need some help, I'm learning powerbi and doing a small project and I need your precious help please.

I have a table called "Consumos1" with the following data:

 

Date/TimeContador MTPT01-GeralQP2-GERAL QP2.4-RefeitórioQE AC5-AVAC + Hotte 
01/01/2023 00:00:002550865964227
02/01/2023 00:00:0031309621274035
03/01/2023 00:00:0038401262328127141
04/01/2023 00:00:0039101395374130158
05/01/2023 00:00:0049201380332126132

 

 

 

 

 

Each column, in addition to the date/time, are counters with the total daily value.

I created a filter and dragged the columns into the filter but instead of showing the name of the columns (of the counters) it shows the values of the counters.
How can I create a filter with the name of the counters (MT Counter, PT01-General QP2-GENERAL, QP2.4-Canteen ,QE AC5-AVAC + Hotte) and then show the data on a card of that counter that I selected in the filter.

Can you please help?

Thank you.

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    One of the first things to learn when you are new to Power Bi is that you need to unpivot your data.

     

    Instead of this

     

    you need this

    Then you can put the attribute column in the slicer.