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 have a column chart and below that I want a matrix/table with additional KPIs. The table columns must be aligned with the chart columns above it. So, for example, if the column chart shows sales for NY, CT & RI, below that I want a table with NY, CT & RI as the columns and additional KPIs as rows. See my attached illustration as an example.
The trouble with adding a matrix underneath my chart is that the number of columns may change depending on the filters. So, if the user filters to just one state for example, the column chart shows one column in the center, but the matrix shows that one column aligned left. I need the table/matrix to adjust the width of its columns just like the chart above it.
I'm looking for something that would basicaly be a multi-column card. Is there any way to do this with the matrix or is there another visual I can download? In Tableau, I would achieve this by creating a column chart visual and a "square" visual and stacking them on top of each other. The columns always aligned regardless of the filter.
@Mainer04401 , There is a custom power bi visual, see if that can serve the purpose
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000675?tab=Overview
@amitchandakThanks ... That visual looks like it would satisfy my requirements but my company does not allow the use of visuals not certified by Power BI 😞