Forum Discussion

JustinOOi's avatar
JustinOOi
New Member
1 year ago

Power BI KPI not changing graphs

The task is to when I click on the KPI box ( which contains the numbers) the graphs below ( employer, salary and skills) will change accordingly to the data there is which I have already linked in the model view  . Can I know if its possible ?



 

Need Help

1 Reply

  • Kedar_Pande's avatar
    Kedar_Pande
    Icon for Super User rankSuper User
    1 year ago

     

    • In Power BI's Model View, ensure that there are correct relationships between the tables feeding your KPIs and the graphs (employer, salary, and skills).
    • Make sure the relationships are either one-to-many or many-to-one and are set to filter the related data accordingly.
    • When using KPI visuals (which seem to represent years in your case), ensure that the year or relevant dimension in the KPI is linked to the data driving the graphs.
    • You can either use a Card Visual or create a custom measure that serves as a slicer when a user clicks on it.