Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello everyone! I’m in need of some help. Currently, I’m trying to create a card using the new visual in Power BI, the “New Card”. However, I’m facing a problem: the information displayed on the card is different from what is in the table.
For example, in the table, it shows that the MH-01 process is associated with IT. However, in the card visual, ED appears. From what I could perceive, the visual is taking the first piece of information and adding it to the card. However, I need the information on the card to be exactly the same as in the table.
Below is a screenshot to better illustrate the situation. I appreciate any help in advance!
Solved! Go to Solution.
Hi @by_tiago
@amitchandak Thank you very much for your prompt reply, please allow me to share some content here.
As the @amitchandak says, the first card does not affect the second card.
They show the first value of each card.
In the "operador" column, the first value is "Ed" in alphabetical order.
Creating a slicer is a good way to do this. It dynamically displays the data you want to display.
If you just want to display the first data statically, you can choose to create a measure.
Measure Operador =
CALCULATE(
SELECTEDVALUE('Table'[operador]),
FILTER(
'Table',
'Table'[processos] = "MH-01"
)
)
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @by_tiago
@amitchandak Thank you very much for your prompt reply, please allow me to share some content here.
As the @amitchandak says, the first card does not affect the second card.
They show the first value of each card.
In the "operador" column, the first value is "Ed" in alphabetical order.
Creating a slicer is a good way to do this. It dynamically displays the data you want to display.
If you just want to display the first data statically, you can choose to create a measure.
Measure Operador =
CALCULATE(
SELECTEDVALUE('Table'[operador]),
FILTER(
'Table',
'Table'[processos] = "MH-01"
)
)
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@by_tiago , if they are columns, a card will take the first value, unless there is a filter via another visual or slicer to give you the exact value. First card visual will not filter second one
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
10 |
User | Count |
---|---|
19 | |
16 | |
14 | |
11 | |
9 |