cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Dynamic Column values based on Slicer Selection

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])

)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Dynamic Column values based on Slicer Selection

@v-pussah 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: Dynamic Column values based on Slicer Selection

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User II
Super User II

Re: Dynamic column values based on segmentation selection

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Support
Community Support

Re: Dynamic Column values based on Slicer Selection

@v-pussah 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Dynamic Column values based on Slicer Selection

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors