filter selection as group in single visuals

Hi esingh ,

This is absolutely achievable in Power BI using a combination of disconnected tables, field parameters, and DAX logic to create a unified visual with grouped bars for, use below DAX to create a disconnected table first:-

CompanyComparisonGroup =
DATATABLE(
"GroupType", STRING,
{
{"Selected Company"},
{"Cohort"},
{"Classification"},
{"All Companies"}
}
)

Make sure you have slicers for:

• Company[CompanyName] — for selected company

• Cohort[CohortName] — for selected cohort

• Classification[ClassName] — for group of companies

Create the Measure to Calculate Values per Group

CompanyGroupMeasure =
VAR SelectedGroup = SELECTEDVALUE(CompanyComparisonGroup[GroupType])
VAR SelectedCompany = SELECTEDVALUE(Company[CompanyName])
VAR SelectedCohort = VALUES(Cohort[CohortName])
VAR SelectedClass = VALUES(Classification[ClassName])

RETURN
SWITCH(
TRUE(),
SelectedGroup = "Selected Company",
CALCULATE([YourMetric], Company[CompanyName] = SelectedCompany),

SelectedGroup = "Cohort",
CALCULATE([YourMetric], FILTER(Company, Company[Cohort] IN SelectedCohort)),

SelectedGroup = "Classification",
CALCULATE([YourMetric], FILTER(Company, Company[Classification] IN SelectedClass)),

SelectedGroup = "All Companies",
CALCULATE([YourMetric]),

BLANK()
)

Build the Visual

• Use a bar chart.

• Set the X-axis to CompanyComparisonGroup[GroupType].

• Use CompanyGroupMeasure as the value.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Hey esingh ,

You can achieve this by creating dynamic measures with DAX and using filter context for each group. Use a slicer for the selected company, a dynamic filter for the cohort, predefined classifications in your data model, and an ALL() function for all companies. Combine these measures in a single bar chart, and use a SWITCH() or IF function in DAX to dynamically switch between the different groups based on the user's selection.

Measure = 
SWITCH(
    TRUE(),
    SELECTEDVALUE(Company[Name]) = "Selected Company", [Measure for Selected Company],
    SELECTEDVALUE(Cohort[Name]) = "Company Cohort", [Measure for Cohort],
    SELECTEDVALUE(Classification[Category]) = "Classification", [Measure for Classification],
    [Measure for All Companies]
)

For Detailed Information:

Dynamic Measures in Power BI

DAX SWITCH Function

Using Filters in Power BI

ALL Function in DAX

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

Hi esingh,

Thank you  for reaching out to the Microsoft fabric community forum.
Thank you grazitti_sapna, for your response regarding the Issue.

It is possible to show all four groups in one bar chart using a disconnected table and a DAX measure with SWITCH logic. Just create a table with "Selected Company", "Cohort", "Classification", and "All Companies" as group labels, and use it as the axis. Add slicers for Company, Cohort, and Classification so the measure calculates each group's value correctly based on user selection.

I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Harshitha.

Hi Community 

Thanks for quick reponse. In my case all the filter have been created based on the individual independent tables which are then associated with main tables.

Selected Company, Cohort Company and Classification are independent filters.

thanks grazitti_sapna Nasif_Azam for the help