To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi experts!
I have a table that shows me open orders, status and the order item:
Order NR | Status | Item |
1 | A | A1 |
Now, I would like to create a visual that shows cards for each order nr with a specific colour coding based on the status. Furthermore, the Item should be displayed as well.
In the end it would be a heatmap with a dynamic number of cards in it since the table has every day a different number of open orders.
Is there any way to do this in Power BI?
Solved! Go to Solution.
Hi , @joshua1990
According to your description, you want to shows cards for each order nr with a specific colour coding based on the status.
If you want to display multiple Orders in the form of cards, the default Power BI visual may not meet your needs.
You can try to use the custom visual in power BI desktop.
Then we can put the field on this visual and we can open the "Conditional format"
Then we can get the visual as follows:
By onther , if you want to use table visual , you can also configure the color, for this , you can refer to :
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @joshua1990
According to your description, you want to shows cards for each order nr with a specific colour coding based on the status.
If you want to display multiple Orders in the form of cards, the default Power BI visual may not meet your needs.
You can try to use the custom visual in power BI desktop.
Then we can put the field on this visual and we can open the "Conditional format"
Then we can get the visual as follows:
By onther , if you want to use table visual , you can also configure the color, for this , you can refer to :
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @v-yueyunzh-msft Aniya,
great visualization, just what i needed, but for some reason the images is only showing 'first' of the imae URL.
i used this multi info card to show my company's machines info cards. our machines includes trucks and excavator, so we have different image url to truck and excavator.
it shows dynamically fine with matrix or table visual. but in this case it only shows the 'aggregated' url which is first or last. so the picture is not accurate (e.g truck info with excavator picture)
do you by chance have a solution for this?
best,
frankie