Dynamic Column values based on Slicer Selection

[v-pussah]

Looking for a solution for the below given problem:-

I have a around 12 columns in a dataset which are plotted in a line chart. Out of this 8 are P1 and 4 are P2 category.

I need to slice these value sin line chart based on the categories (P1 and P2) in such a way that it only shows 4 P2 on selection of P2 or vice-versa.

I created a custom table with 2 columns having features and categories and wrote Switch statement on the selected value, but it’s not working.

Selection = SWITCH(TRUE(),

SELECTEDVALUE('Feature Selection'[Features]) = "ThirdPartyActiveUsage", SUM(TenantData[Third Party Active Usage]),

SELECTEDVALUE('Feature Selection'[Features]) = "CAActiveUsage", SUM(TenantData[CA Active Usage]),

SELECTEDVALUE('Feature Selection'[Features]) = "AppProxyActiveUsage", SUM(TenantData[AppProxy Active Usage])

)

[v-chuncz-msft · Accepted solution]

@v-pussah 

You may aslo try Unpivot Columns in Query Editor, then take advantage of the Legend field.

[v-pussah]

Unpivoting is the solution, but the problem is size of data. by unpivoting it has 25M rows.

[Anonymous]

Hello @v-pussah ,

I think you can use the bookmark function to do it.

Create two tables, one for P1, one for P2, and create two markers for these two tables.

Next, create a column with two values, such as: P1 and P2.

Click P1 for bookmarks, P2 for markers, and for the button, you can use force selection.

Please try.

Aiolos Zhao

[amitchandak]

@v-pussah,The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output.

Appreciate your Kudos.