Sankey Custom Visual - Is it possible to create a measure that allows choice of Source off a slicer

[mwimberger]

Hi folks and happy Friday!

I'm using a Sankey custom visual to track material flow. My question relates to the Source and Destination fields which reference columns in a table and whether these columns can be changed using a slicer linked to a measure possibly using SWITCH or something similar.

The reason for this is I have used groupings to generate various levels of detail in types of sources and destinations, a bit like a hierachy.

Here is my attempt at a switch code - but of course it doesn't work due to the nature of SWITCH - only returning one scalar value and not columns.

Source Level Choice= 
IF (
    HASONEVALUE(tblkpLevel[Column1] ),
    SWITCH (
        VALUES ( tblkpLevel[Column1]   ),
        "Level 0", 'tblSource'[SourceGroupL1],
        "Level 1",'tblSource'[SourcegGroupL2],
        "Level 2", 'tblSource'[SpurceGroupL3],
      
        BLANK ()
    ),
    [No Choice Made]
)

I would like my users to be able to drill down to various levels - and not have to select different tabs. Any pointers would be hugely appreciated.

Cheers

Manfred

[v-frfei-msft]

Hi @mwimberger ,

I suggest to use bookmark to work around.

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

For Dynamic X-axis as per parameter selected, Please refer to this case.

https://community.powerbi.com/t5/Desktop/Dynamic-X-axis-as-per-parameter-selected/td-p/711660