Forum Discussion

trabass's avatar
trabass
Frequent Visitor
8 years ago
Solved

Visual Filters vs Measures on a table

Hi There,  Struggling to figure out a filter, sure it's simple but I'm stuck.    Currently I have three visual filters setup on dashboard - company, financial year, quarter. For example.  If I cha...
  • trabass's avatar
    trabass
    8 years ago

    Hi Dale,

     

    Thanks for the response.  I'll put together a dummy pbix file and add it.  Would like to learn how to make this work.

     

    1. Are Tasks[BenefitTarget1] and Tasks[BenefitActual1] measures or columns?  > These are columns of data

     

    2. Where are the fields of the slicers from? Are they from the three 1-side data tables? > Yes.  I created them so i had unique key to filter between the tables.

     

    3. How did you make the visual table? Some fields should from the 1-side data tables.  > No, i didn't know this.  The table on the dashboard is just off the tasks table.  I will change it.

     

    Could you please share a dummy pbix file?

trabass's avatar
trabass
Frequent Visitor
8 years ago

Hi Dale,

 

Thanks for the response.  I'll put together a dummy pbix file and add it.  Would like to learn how to make this work.

 

1. Are Tasks[BenefitTarget1] and Tasks[BenefitActual1] measures or columns?  > These are columns of data

 

2. Where are the fields of the slicers from? Are they from the three 1-side data tables? > Yes.  I created them so i had unique key to filter between the tables.

 

3. How did you make the visual table? Some fields should from the 1-side data tables.  > No, i didn't know this.  The table on the dashboard is just off the tasks table.  I will change it.

 

Could you please share a dummy pbix file?

trabass's avatar
trabass
Frequent Visitor
8 years ago

Thanks for your help.  Yes adding in the 1-sided fields would resolve the problem.