How Create filter with collumn headers

[newbiepb]

Hello,

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	2550	865	96	42	27
02/01/2023	3130	962	127	40	35
03/01/2023	3840	1262	328	127	141
04/01/2023	3910	1395	374	130	158
05/01/2023	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.

Thank you, for the help.

[Ritaf1983 · Accepted solution]

Hi @newbiepb 
If I understood you correctly and you want the option to select a measure, you can use the field parameters functionality.
For more information, please refer to the linked tutorial:

https://www.youtube.com/watch?v=V6WchPDZibI

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

[newbiepb]

Amazing, thank you @Ritaf1983  for the amazing Help 🙂

[Ritaf1983]

Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @newbiepb 
If I understood you correctly and you want the option to select a measure, you can use the field parameters functionality.
For more information, please refer to the linked tutorial:

https://www.youtube.com/watch?v=V6WchPDZibI

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

[newbiepb]

Hello,

I created the filter with the New Parameter option.

I created a card to give me the total value of each selected filter, which is in the blue rectangle.

However, when I select the counter filter, the value does not filter for that counter.

Please check my PBIX file: https://we.tl/t-lp5fI1GSpo

[Ritaf1983 · Accepted solution]

Hi @newbiepb 
You need at the first step create the measures for the parameters.

Then use these measures as a parameters

And Put the parameter in the cart

Result:

Pbix is attached.

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