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
eliasayyy
Super User
Super User

Dynamic Top N based on Field Parameter Measure Slicer

Hello Everyone I have a table :

Campaign        Impressions        Clicks          Cost
Camp A970201907629.02
Camp B68593958643.53
Camp C74586273736.35
Camp D685671679319.12
Camp E799681099834.62
Camp F84165945830.22
Camp G90861335022.57
Camp H53139341531.65
Camp I59105367429.83
Camp J687191799630.36

 

i created 5 measures

 

 

Total Impresions = SUM(table[Impressions])

Total Link Clicks = SUM(table[Clicks])

Total Cost = SUM(table[Cost])

CTR = DIVIDE([Total Link Clicks] , [Total Impressions] , 0 )

CPC = DIVIDE([Total Cost] , [Total Link Clicks] , 0 )

 

 

 

 

i created a field parameter for the measures and named it "Measure Slicer"

I added a Column Chart Visual and in the x- axis , the campaign name and y-axis my "Measure Slicer" measures

I added the "Measure Slicer" Slicer and I'm able to switch between measures easily.

now i want to show top 3 campaigns DESC based on each measure selected, any idea how to do it?

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @eliasayyy 
Please refer to attached sample file with the solution

1.png2.png3.png

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @eliasayyy 
Please refer to attached sample file with the solution

1.png2.png3.png

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.

Top Solution Authors