Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
Happy to help 🙂
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
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.
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