Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
EmilioMadrid
Frequent Visitor

Double dynamic segmentation

Hi everybody,

 

I'm preparing a report with a double dynamic segmentation that doesn't work, so I ask your help.

 

I've got a table with dates, locations and number de events, similar to:

 

DateLocationNumber of events
01/09/2020Madrid10
01/09/2020Barcelona1
01/09/2020Sevilla2
02/09/2020Madrid2
02/09/2020Sevilla8
03/09/2020Barcelona1
04/09/2020Madrid1

 

And in the report I have 2 data segmentations, (Emilioglez_0-1608025608436.png) one for "dates" and the other for sum of "number of events". The limits of this one (sum of "number of events") must be between the allowed possibilities according to the date segmentation.

 

With the one for "dates", obviously, I filter the dates, and with the one for "number of events", I want to retrieve the locations whose sum of events in the filtered period are between the marked limits and the sum of their events.

 

Examples:

 

A) if I select in date segmentation:

Emilioglez_1-1608026097481.png

Then, the sum of "number of events" segmentation must be:

Emilioglez_2-1608026512373.png

If, in this case, I don't move the "number of events" segmentation, the result must be:

Emilioglez_3-1608026590723.png

 

But, if I select:

Emilioglez_4-1608026629003.png

 

I must get the locations whose sum of events in this period are between 7 and 13: 

 

Emilioglez_5-1608026654358.png

 

B) If the date segmentation is:

Emilioglez_6-1608026978822.png

Then, the sum of "number of events" segmentation must be (please, notice that now it's between 2 and 8, due to the number of events it's something dynamic in the original data):

Emilioglez_7-1608027129882.png

So, in this case, the result must be:

Emilioglez_8-1608027190348.png

 

And, if I move the maximum from the sum of "number of events":

Emilioglez_9-1608027234520.png

 

The result must be:

Emilioglez_10-1608027273749.png

 

 

Can someone help me to solve this issue?

 

Thanks in advance.

 

Best regards!

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @EmilioMadrid,

So you mean the second slicer should be dynamic changes based on the selection of slier1?

If this is the case, it not an issue, both slicers are work as expected. You can use the slicer to filter another slicer items(power bi use and logic to link filters) but selected filter range not able to dynamic changes based on the filter interactions.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

HI @EmilioMadrid,

So you mean the second slicer should be dynamic changes based on the selection of slier1?

If this is the case, it not an issue, both slicers are work as expected. You can use the slicer to filter another slicer items(power bi use and logic to link filters) but selected filter range not able to dynamic changes based on the filter interactions.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi, Xiaoxin,

 

Thanks for response. So, sadly, it's something that can't be done.

 

Regards.

Hi, Amitchandak, thanks a lot.

 

I'm not so professional as you to solve this problem. The first part, the date slicer is easy and I had done it before.

 

The problem to me is to get the second slider, that must be dynamic, in the sense that the first value that let you to select and the last one must be the extremes of the possible values in the previously selected date range.

 

I've read the links that you attached, but, as I mentioned, I'm not so good in PowerBI yet and the tests that I have done based on them have failed...

 

If you could give me a small solution based on my example I would appreciate it infinite.

 

Thanks a lot.

 

Emilio.

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors