Filter data with dynamic segmentation

[Anonymous]

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 table.

Here some images:

As you guys can see, i can filter data with table, but with segmentation i dont.

am i missing something or anything?

Thanks in advance.

[v-huizhn-msft]

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]

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]

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 · Accepted solution]

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!