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
PowerUser123
Helper II
Helper II

Combine Two Slicer Values from Same Data

I have a list of companies. The final product of the dashboard would have two slicers. One slicer is for the user to select the company the analysis should be performed on. The second slicer lets the user choose other companies to compare the first selected company against.

 

The rest of the dashboard really just needs to show all the companies selected from both slicers. The benefit of having the two slicers is that I would need to sometimes refer to or know the specific company selected in the first slicer.

 

For example,

 

User selects AAPL in the first slicer

 

User selects NFLX, GOOG, MSFT in the second slicer.

 

The analysis throughout the dashboard would show data for AAPL, NFLX, GOOG, and MSFT. But there are certain pages of the dashboard where I need to call out the AAPL selection or do calaculations involving it.

2 REPLIES 2
PowerUser123
Helper II
Helper II

@jaweher899 Thanks for the reply. I understand the selectedvalue dax code and such. I'm not understanding how I can create two slicers that will work how I'd like.

I have one list of companies. If I create two slicers based on this list (one for the main company, one for the comparison companies) the slicers won't work in sync. If I select 3 companies from the comparison slicer and then try to select a company from the main slicer, the main slicer would override the other or vice-versa. I need the slicers to work together and include both slicer selections rather than filtering each other. 

jaweher899
Super User
Super User

You can create two slicers in PowerBI, one for the main company to analyze and one for comparison companies. To refer to the selected company in the first slicer, you can create a calculated column that returns the selected value of the slicer. You can then use this calculated column in your analysis and visualization to compare the selected companies. Additionally, you can use DAX functions such as "SELECTEDVALUE" or "CALCULATE" to manipulate and reference the selected values from the slicers in your calculations and visualizations.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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