Power KPI Matrix

[dearnest]

I am trying to use the Power KPI Matrix visual with multiple databases/tables.  The problem is when I select that Date from one table it doesnt show data from the other tables even when Values are selected.  How do I connect these tables to each other and teh Power KPI Matriz visual to be able to have seperate input databases operating in the same visual (the magic of PowerBI)?  I have tried a seperate Date table and creating relationship between them on Dates but that didnt yield any fruit. 

[Anonymous]

Hi @dearnest ,

Which fields do you need to apply to your KPI Matrix visual? Are these fields from multiple tables? If so, how did you create the relationships between these tables? Please provide relevant screenshots of your data model setting. And please provide some sample data from these tables, later we need to check why there are fields that are put into the Values option but the visual still don't show data... It would be nice if you could provide a simplified pbix file so that we can find the cause of problem faster and easier and provide you with a appropriate solution. You can refer the following thread to upload your pbix file in your thread.

How to upload PBI in Community

Best Regards

[amitchandak]

@dearnest , based on what I got, You need to have a common date table and join that with all other fact tables on the required date column. Use common dimensions as per requirements

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.