Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter data with dynamic segmentation

Hi, iw as trying to filter some data using dynamic segmentation and its not working.   I tried and realted the columns but i didnt achieved the wondered result.   Unfortunetly, i achieved using t...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi v-huizhn-msft, thanks a lot for you attention.

     

    I manage a solution to affect the card.

     

    What i did was so simple that i dont believe i didnt tought before. Once i already had the relationship between the tables, I created another column in my table where's i use in the slice with these data. So, i just put selected the data to display on card.

     

    I didnt tried like you said, but in the future i'll try!

     

    Thanks again for your time!

     

     

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

In the third screenshot, you want to display 218 for Braskem rather than 8084, right? If it is, what measure did you use in the card visual? Please share the formula. And let the slicer affect card visual by interactions under modeling.

Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-huizhn-msft

 

Yes, That's exatcly what i want.

 

Let me explain how i did the measure:

 

First, i have a oracle database that i have all information about these sites, but i dont have a head count for the employees that i need. So, i have another source, but in Excel file with this data. In this Excel i made these formula to calculate the head count:

 

Calculate total of effective employees

 

Colaboradores efetivos total = SUM(DataBI2_RMensal[Nº de funcionários efetivos]

 

Calculate total of third-part employees

Colaboradores temporarios total = SUM(DataBI2_RMensal[Nº de funcionários temporarios])

 

And calculate the total of employees (effectives and third-part) for the sites.

HEAD TOTAL = CALCULATE(DataBI2_RMensal[Colabres efetiv-ios total] + DataBI2_RMensal[colabores temporarios total])

 

 

Then, i made a relationship between my site_id in my oracle database and my excel file (TB_PIRAMIDE = oracle dabatase and DataBI2_RMensal = excel file), like this:

 

 And so i wondered that if i put in dynamic segmentation the sites, these would be filtered with the head total by site like the previous images.

 

So far, i dont understand how can i affect the card visual by interactions under modeling, could you give some example?

 

I tought that if i made a relationship between these tables all the data would be filtered.

 

Thanks in advance.

 

 

 

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    First, please see the following screenshot, the slicer will affect card and table visuals when you select the funnel button.


    In your scenario, please comfirm the filter across as both.

    Best Regards,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-huizhn-msft, thanks a lot for you attention.

       

      I manage a solution to affect the card.

       

      What i did was so simple that i dont believe i didnt tought before. Once i already had the relationship between the tables, I created another column in my table where's i use in the slice with these data. So, i just put selected the data to display on card.

       

      I didnt tried like you said, but in the future i'll try!

       

      Thanks again for your time!