Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
newbiepb
New Member

How Create filter with collumn headers

Hello,

 

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 2550865964227
02/01/2023 31309621274035
03/01/2023 38401262328127141
04/01/2023 39101395374130158
05/01/2023 49201380332126132

 

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.

1 ACCEPTED SOLUTION

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

Ritaf1983_0-1700449879340.png

Ritaf1983_1-1700449926432.png

Then use these measures as a parameters

Ritaf1983_2-1700450030701.png

And Put the parameter in the cart

Ritaf1983_3-1700450427460.png

Result:

Ritaf1983_4-1700450455300.png

Pbix is attached.

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
newbiepb
New Member

Amazing, thank you @Ritaf1983  for the amazing Help 🙂

Happy to help 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Ritaf1983
Super User
Super User

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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

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

Ritaf1983_0-1700449879340.png

Ritaf1983_1-1700449926432.png

Then use these measures as a parameters

Ritaf1983_2-1700450030701.png

And Put the parameter in the cart

Ritaf1983_3-1700450427460.png

Result:

Ritaf1983_4-1700450455300.png

Pbix is attached.

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors