Forum Discussion
Card Visual - Dynamic Position by the number
Hello, I tried with no sucess to make a card with 5 numbers to show (MAX, MEDIAN, AVG, MIN and the one that floats), anyone knows how can I do this on PowerBI?
A practical example:
MAX - 10
MEDIAN - 7
AVG - 6
MIN - 0
when I choose UserA on filter card, his number is 8, so it should appear after MEDIAN and behind MAX...
if i choose UserB and his number is 3, it should appear after MIN and behind AVG...
Hi Anonymous
The request is unclear.
If you want to put multiple measures you can use a new card visual,
For more information please refer to:
https://www.youtube.com/watch?v=jvwT1KS86dU
if you want to put all the measures on one card you can create a tex measure like :
all_measures = "Total sales: " &[Total sales]&UNICHAR(10)&"Max sales : " &[max_]&UNICHAR(10)&"Min sales: " &[min_Sales]Pbix is attached
If it is something else
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
pls try
6 Replies
Hi Anonymous
The request is unclear.
If you want to put multiple measures you can use a new card visual,
For more information please refer to:
https://www.youtube.com/watch?v=jvwT1KS86dU
if you want to put all the measures on one card you can create a tex measure like :
all_measures = "Total sales: " &[Total sales]&UNICHAR(10)&"Max sales : " &[max_]&UNICHAR(10)&"Min sales: " &[min_Sales]Pbix is attached
If it is something else
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
share an example pbix, I'll help you
Hello, the pbix file - https://we.tl/t-FnN9ZEF528
My "ok solution" was the bar chart
For example, when I select the id 7, I wanted that the card with "Value ID" took space between MAX and AVG, cause is <500 and >180,50..pls try