Help to create filter

[newbiepb]

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/Time	Contador MT	PT01-Geral	QP2-GERAL	QP2.4-Refeitório	QE AC5-AVAC + Hotte
01/01/2023 00:00:00	2550	865	96	42	27
02/01/2023 00:00:00	3130	962	127	40	35
03/01/2023 00:00:00	3840	1262	328	127	141
04/01/2023 00:00:00	3910	1395	374	130	158
05/01/2023 00:00:00	4920	1380	332	126	132

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.

[lbendlin]

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.