Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Chetanab
Employee
Employee

Filter a table based on measure selection from a clustered bar chart

I have a table with 3 columns - ID, CreateDate, ClosedDate.

In visuals, I have a clustered column chart with two measures - Monthyear on x axis, Measures are 1)Created Cases ='table'( distinctcount(ID) )2)Closed Cases = calculate('table'(distinctcount(ID),Userelationship('datetable'[date], 'Table'[ClosedDate]))

 

I also have a table visual with ID, CreateDate,ClosedDate. I want to filter this table by clicking on the individual Created Cases/Closed Cases bars and be able to view the respectives IDs and their details. for example, when I click on the Created Cases bar for the month of March 2023 in the clustered column chart, the table below should show IDs created in march.

 

I am able to achieve this using a slicer that has created cases and closed cases options(Using selectedvalue). I am trying to understand if there's a way to filter the table without using a slicer,i.e directly be able to filter from the column chart

 

2 REPLIES 2
Chetanab
Employee
Employee

Thanks for getting back. Here's some sample data

 

IDCreate DateClosed Date
11/1/20231/31/2023
21/2/20231/31/2023
31/3/20232/1/2023
42/23/20232/27/2023
52/24/20233/1/2023
62/4/20233/24/2023
73/1/20233/24/2023
83/4/20233/31/2023
93/3/20233/4/2023

 

Here are my visuals - 

Chetanab_0-1681226292163.png

Desired solution - Filter below table to created cases when clicked on created cases and closed cases when clicked on closed cases. Currently it filters Created cases correctly because there is an active relationship between table[createddate] and date[date]. But when I selected Closed cases, It should return 2 rows for the  month of Jan as shown below - 

Chetanab_1-1681226606803.png

I am able to achieve the desired soultion using a slicer. Just wondering if there is a way to achieve it without a slicer. 

Chetanab_2-1681227972576.png

For slicer I created a MeasureTable and used selected value

Chetanab_3-1681228019248.png

 

 

 

amitchandak
Super User
Super User

@Chetanab , Not very clear. But check the field parameters and Calculation group

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

 

Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA

 

Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

 

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.