Show selected parameter fields on cards

[idkwhatimdoing]

I am trying to use the new card visual to display all the values of the parameter fields based on what parameter is selected. I have a simplified sample below, although the measures aren't currently correct. I want the user to select the parameter then the field values and the visual will display those values in the card. then I have added measures as reference labels to each visual showing more metrics about each field value. 

I can't figure how to set this up, assuming it's possible. Thank you in advance for any suggestions. 

NB, my firewall won't allow me to access sites like google drive for sharing data, so I haven't figured out where to post my sample file if it's needed. 

[Anonymous · Accepted solution]

Thanks for the reply from amitchandak , please allow me to provide another insight:

Hi, @idkwhatimdoing 

Based on my current testing, placing the parameter field directly in the new card visual is not feasible. Here are my findings:

To better align with your needs, I propose the following solution:

1.Firstly, copy the query in Power Query.

2.Secondly, modify the column names to match the first row.

3.Adjust the new card visual accordingly.

4.Then, create a measure and modify the following settings for each column.

1 = CONCATENATEX(
    'Table',
    'Table'[Column1],
     UNICHAR(10) 
)

2 = CONCATENATEX(
    'Table',
    'Table'[Column2],
     UNICHAR(10) 
)

3 = CONCATENATEX(
    'Table',
   'Table'[Column3],
     UNICHAR(10) 
)

5.The final results are as follows:

Of course, you might find other visual objects, such as a table or matrix, to be quite useful as well.

If you discover any new solutions, we would love for you to share them with us!

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[idkwhatimdoing · Accepted solution]

I was able to find a custom visual that displays the categories in the method I'm seeking: Multi Info Cards. It just doesn't allow as much customization as the built-in new cards visual. So I'm still open to suggestions. 

[Anonymous · Accepted solution]

Thanks for the reply from amitchandak , please allow me to provide another insight:

Hi, @idkwhatimdoing 

Based on my current testing, placing the parameter field directly in the new card visual is not feasible. Here are my findings:

To better align with your needs, I propose the following solution:

1.Firstly, copy the query in Power Query.

2.Secondly, modify the column names to match the first row.

3.Adjust the new card visual accordingly.

4.Then, create a measure and modify the following settings for each column.

1 = CONCATENATEX(
    'Table',
    'Table'[Column1],
     UNICHAR(10) 
)

2 = CONCATENATEX(
    'Table',
    'Table'[Column2],
     UNICHAR(10) 
)

3 = CONCATENATEX(
    'Table',
   'Table'[Column3],
     UNICHAR(10) 
)

5.The final results are as follows:

Of course, you might find other visual objects, such as a table or matrix, to be quite useful as well.

If you discover any new solutions, we would love for you to share them with us!

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[idkwhatimdoing]

@Anonymous, Thank you for your response and the thorough instructions. I like your creative solution. However, I'm not sure how to apply it to my more complex situation. I have many measures that I will need to attach to each category and over 1,000 rows in my real data. I will play around with your suggestions a bit more with my data. Thank you.

[amitchandak]

@idkwhatimdoing , You can get selected filed parameter based on

Selected Parameter = maxx(filter(Parameter ,Parameter[Parameter Order] = SELECTEDVALUE(Parameter[Parameter Order])), Parameter[Parameter])

The based that you still need static measure to get all measure

Switch( True(),

[Selected Paramete] ="Category", concatenatex(Values(Item[Category]), [Category], ", ") ,

//Add code for others

)

[idkwhatimdoing]

Thank you for your response, @amitchandak. I actually do have measures similar to these. (It's always validating to know that I'm on the right track with at least part of my model 🙂!) However it won't give me the categories separately in each card to link to my measures. Perhaps I oversimplified my problem or I'm going about this the wrong way... or both. I will keep playing around with it. Thanks again.