Forum Discussion

RJPowerBI's avatar
RJPowerBI
Frequent Visitor
7 years ago
Solved

Two slicers slicing two tables

  Hi, I have a page in my PowerBI report which shows failed KPI IT tickets. I'm displaying the data as a list in two tables. The data is held in two tables in PowerBI from an Excel spreadsheet. The ...
General Comment
  • RJPowerBI's avatar
    RJPowerBI
    7 years ago

    Thanks for replying and the tip to do sample data.

     

    I created a new excel spreadsheet and started populating with dummy data.  I imported this in to powerbi and low and behold it worked perfectly.

     

    I started to play with my original powerbi and it turned out the weeks worksheet was doing something funky.  I deleted the worksheet and re-created.  Deleted the weeks table in powerbi and reimported.  The relationships now automatically create and it works as I want it to.

RJPowerBI's avatar
RJPowerBI
Frequent Visitor
7 years ago

Thanks for replying and the tip to do sample data.

 

I created a new excel spreadsheet and started populating with dummy data.  I imported this in to powerbi and low and behold it worked perfectly.

 

I started to play with my original powerbi and it turned out the weeks worksheet was doing something funky.  I deleted the worksheet and re-created.  Deleted the weeks table in powerbi and reimported.  The relationships now automatically create and it works as I want it to.

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi RJPowerBI ,

It's pleasant that your problem has been solved, could you please mark my reply as Answered to close this topic?

 

Regards,

Daniel He