The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I created this power bi report over 1.5 year ago. At the time I used the visual Card. The Card is static, if you click on the card it does not link to the table, and the table doesnt update to the card status selection.
The new Visual Multi-row Card is great. In the multi-card when you click on a Status, the Table updates to display items of the status.
The users like how the Card Status colour matches the Status in the Table.
In the visual Multi-row Card is there a way to change the colour of the text/values for individual values/text?
Also can the card Status colours be pre-set? for example at the moment there is no Status Completed. In the data source if users change an item status to Completed, will the Visual Multi-row Card automatically show Completed as colour green. Or will I manually have to update the report each time? Or is there another way to solve this?
TIA
Solved! Go to Solution.
Hi @dd88
What allows the interactivity of the cards with the table is the context provided by the category (thanks to the fact that it's not a separate measure for each status).
The limitation of the card visualizations we have is that we can't apply conditional formatting based on categories, only on measures. Therefore, in this visualization, there's no way to both define colors based on status and maintain interactivity.
In terms of alternatives, there is a visualization type called "Multi Info Cards" which allow conditional formatting of the background based on the category.
For example, I have a sample file with sales and age groups and want to modify the separate colors of the age group.
I created a needed dax of coloring:
Age group color =
SWITCH(SELECTEDVALUE('Customers'[Age group]),
"35-44","#f4a582",
"25-34","#fdae61",
"#b2abd2")
If I will try to use it in the score card , nothing will change :
The same logic with "Multi Info Cards" will give us the results:
The drawback of this visualization is that it has very limited design options, and the color settings apply only to the background color.
If you still decide to use it, here is its image in the marketplace:
Other alternative is to generate something similar from the core table :
And the last idea use rectangles with the visual :
The pbix with all the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
An alternative would be the Cards (new) visual that allow you to display multiple measures in a grid.
There are pros and cons to this visual as well.
Pros:
Cons:
Thank you @Ritaf1983 thats great, they are great solutions & possiblities. I will look at the sample template provided to try and work out how best to use
Thank you again
Happy to help 🙂
Hi @dd88
What allows the interactivity of the cards with the table is the context provided by the category (thanks to the fact that it's not a separate measure for each status).
The limitation of the card visualizations we have is that we can't apply conditional formatting based on categories, only on measures. Therefore, in this visualization, there's no way to both define colors based on status and maintain interactivity.
In terms of alternatives, there is a visualization type called "Multi Info Cards" which allow conditional formatting of the background based on the category.
For example, I have a sample file with sales and age groups and want to modify the separate colors of the age group.
I created a needed dax of coloring:
Age group color =
SWITCH(SELECTEDVALUE('Customers'[Age group]),
"35-44","#f4a582",
"25-34","#fdae61",
"#b2abd2")
If I will try to use it in the score card , nothing will change :
The same logic with "Multi Info Cards" will give us the results:
The drawback of this visualization is that it has very limited design options, and the color settings apply only to the background color.
If you still decide to use it, here is its image in the marketplace:
Other alternative is to generate something similar from the core table :
And the last idea use rectangles with the visual :
The pbix with all the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly