Forum Discussion
Power KPI Matrix
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 se...
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.