Forum Discussion
Display KPIs per Products
This type of dynamic layout isn't directly supported by default in Power BI, but you can achieve a similar effect with some creative workarounds. Here’s how you might approach it:
1. Dynamic Visibility with Bookmarks and Selection Pane:
- Create separate KPI card visuals for each product and arrange them in your desired layout.
- Use the Selection Pane to create groups for each set of KPI visuals by product.
- Set up bookmarks for each possible number of products (e.g., 3, 5, 8 products).
- Use a slicer or parameter to control which bookmark is displayed based on the tenant's number of products.
2. Dynamic Titles and KPIs with Measures:
- Instead of using individual visuals for each product, create a matrix or table that lists products as rows and displays KPIs as columns. Use DAX to conditionally display KPIs based on the tenant’s available products.
- For each KPI measure, use `IF` conditions to show values only if the product is available for that tenant.
3. Use of a Custom Visual:
- Power BI's custom visuals marketplace has visuals that might provide more flexibility in layout. Card with States or Multi-row Card might help display KPIs in a more compact form based on conditions, but you may need to try different visuals to see which works best for your requirements.
4. Paginated Reports:
- If you're using Power BI Premium, you could consider using Paginated Reports. These allow for more flexibility with dynamic layouts based on filters and are more suitable for varying content based on the number of products.
Each approach has its limitations, but these workarounds can help achieve a dynamic display based on the number of products per tenant. Let me know if you need more details on any of these!