Forum Discussion

limewire's avatar
limewire
Icon for Helper I rankHelper I
7 years ago

Use appended data slicers with merged data

I'm having issues with this and I've looked around but I can't quite solve it on my own. 

 

Current Situation:

I have two tables with data, L+7 data and L+SD data.

 

The tables are formatted identically and both contain data on 2 different channels. What I've done is append L+7 with L+SD so that I was able to use visual slicers that would filter for L+7 vs. L+SD and channel 1 vs. channel 2.

 

I then made another table that merged L+7 and L+SD so that I could have a calucated column for DVR lift, or rather the number of impressions from L+7 - L+SD. Using that column I created two more calucated columns in the report that deal with the % total and the % lift.

 

I now have a merged table and an appended table, both with L+7 data and L+SD data. How can I use my appended table slicers with my merged data visualization card? 

Should I have tackled this differently from the start?

 

Thanks in advance! Hoping someone can help. 

Need Help
Tutorial Requests

3 Replies

    • limewire's avatar
      limewire
      Icon for Helper I rankHelper I
      7 years ago

      v-chuncz-msft 

       

      Thank you for your suggestion!

       

      I've tried to make relationships between the tables work but no such relationship can be created since I have a demo sort table.

       

      This demo sort table is to help organzie my demos so they appear in the order I want. Relationship IssueAll relationships