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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
justinMcC
Frequent Visitor

Measure to x axis chart or dymanic table

Hi,

 

 

I have a using a table, measure and slicer to categorise my data. I need to create a chart showing the result of measure, which I need to update when user changes value of slicer. Below is sample data

 

Table:

Clients     Min_eligible

client_1    10

client_2    20

client_3    30

 

Slicer:

10

20    (eg selected value)

30 

 

Measure:

IF min_eligible < slicer, 'partical' else 'full'

 

Result:

Clients     Min_eligible    Measure

client_1    10                   Partial

client_2    19                   Partial

client_3    30                   Full

 

I need to create a clusterd chart showing measure and count of clients, ie

 

Full        1

Partial    2

 

I need the above result to auto update if the end user changes the selected value in slicer. Is there any way I can create a dynamic column or table from the above. The main requirement I have is that it needs to update on slicer selection change.

 

Thanks for your help

 

Regards

 

JustinMc

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@justinMcC,

I make the following  table using your sample data.
1.JPG2.JPG

Create the following measures in the first table.
Measure  = IF(MAX(Table1[Min_eligibe])<MAX(Table2[Column1]),"partical","full")
partical = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]<MAX(Table2[Column1])))
full = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]>=MAX(Table2[Column1])))

Create visuals as shown in the following screenshot.
3.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
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

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@justinMcC,

I make the following  table using your sample data.
1.JPG2.JPG

Create the following measures in the first table.
Measure  = IF(MAX(Table1[Min_eligibe])<MAX(Table2[Column1]),"partical","full")
partical = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]<MAX(Table2[Column1])))
full = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[Min_eligibe]>=MAX(Table2[Column1])))

Create visuals as shown in the following screenshot.
3.JPG

Regards,
Lydia

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

Thanks @v-yuezhe-msft

 

I used a modified version of your DAX formula. It worked great, thanks for your help - it really helped me out with customer issue

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.