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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Robert93
Regular Visitor

Overlapping data slicer

Hi guys,

 

I have an interesting one that I am unsure how to tackle.

 

I have several pieces of wire connecting to each other over a length, the wires overlap each other as they transition to the next wire. We measure the thicknesses of these wires.

 

I would like to create a slicer that can look at each individual wire.

 

For example,

1      2      3      4     5     6     7     8 km

------------ wire A

         ---------------- Wire B

                         --------------------- Wire C

 

Wire A spans from 1km to 3km

Wire B spans from 2km to 5km

Wire C spans from 4km to 8km

 

Where these wires overlap, is where they join one another.

 

I would like to add a slicer to my visual where if someone selects the wire it shows the data in these km ranges (1 - 3, 2 - 5, 4-8).

 

Any help would be greatly appreciated.

 

 

1 ACCEPTED SOLUTION

@Robert93 Disconnected tables are just tables with no relationship between them. I have mocked up a solution in attached PBIX below sig. You want Page 8, Table (8) and Table (8a). Basically, split your wire range out into a min and max and then implemented a Complex Selector that you use in your Filters pane.

Measure 8 = 
    VAR __Currentkm = MAX('Table (8)'[km location])
    VAR __Minkm = MIN('Table (8a)'[km locations min])
    VAR __Maxkm = MAX('Table (8a)'[km locations max])
RETURN
    IF(__Currentkm>=__Minkm && __Currentkm <= __Maxkm,1,0)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
stevedep
Memorable Member
Memorable Member

With respect to the technique to use, you could take a look at this one, seems pretty simular:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Time-Measure-Productive-hours-with-duplicates...

 

Kind regards,

 

 

Steve. 

Greg_Deckler
Super User
Super User

@Robert93 Sounds interesting but would need sample source data to put together a solution. Probably going to involve a disconnected table or potentially binning. Hard to say with the information provided. 

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler,

 

thanks for the quick reply.

 

Sample data would be something like the following,

 

km locationthickness (cm)
012
1

10

211
312
413
515
616
712
810
915
109

 

And from the knowledge of the sections, I know that,

 

Wirekm locations
A1 to 3
B2 to 6
5 to 8
D7 to 10

 

The overlapping sections of wire are where they join to one another (one gradually decreases while the other gradually increases). This is sample data where the overlaps are 1 km. Really these are smaller values but the idea is the same.

 

I have the first set of data plotted out over a line visual, I would like to have a slicer that has options Wire A, Wire B, Wire C, and Wire D. When selected, the km axis just shows data in that range.

 

More than happy to learn the ways to make this happen. I haven't heard of either disconnected tables or binning.

 

Any help would be greatly appreciated.

@Robert93 Disconnected tables are just tables with no relationship between them. I have mocked up a solution in attached PBIX below sig. You want Page 8, Table (8) and Table (8a). Basically, split your wire range out into a min and max and then implemented a Complex Selector that you use in your Filters pane.

Measure 8 = 
    VAR __Currentkm = MAX('Table (8)'[km location])
    VAR __Minkm = MIN('Table (8a)'[km locations min])
    VAR __Maxkm = MAX('Table (8a)'[km locations max])
RETURN
    IF(__Currentkm>=__Minkm && __Currentkm <= __Maxkm,1,0)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler

 

Thank you mate! Turned out great, appreciate the help 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors