How to create a dynamic card in Power BI
Power BI is a platform that allows you to connect to various data sources, transform and model your data, and create interactive dashboards and reports. Power BI can help you gain insights from your data and communicate them effectively.
What is a card visual in Power BI?
A dynamic card in Power BI is a card visualization that changes based on the context or user interaction. It’s often used to display key metrics or data that are relevant to a specific selection or filter. For example, you might have a dynamic card that displays sales data for a specific region. If a user applies a filter to select a different region, the card updates to display the sales data for the newly selected region.
Building the dynamic card
We will be making this dynamic card:
The card will show all those regions which are selected by the slicer separated by the delimiter comma ‘ , ‘.
1.DAX for dynamic card creation:
Dynamic Card = IF(ISFILTERED(Table1[Region]), CONCATENATEX(DISTINCT(Table1[Region]),Table1[Region],”, “…