Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Everyone I have a table :
Campaign | Impressions | Clicks | Cost |
Camp A | 97020 | 19076 | 29.02 |
Camp B | 68593 | 9586 | 43.53 |
Camp C | 74586 | 2737 | 36.35 |
Camp D | 68567 | 16793 | 19.12 |
Camp E | 79968 | 10998 | 34.62 |
Camp F | 84165 | 9458 | 30.22 |
Camp G | 9086 | 13350 | 22.57 |
Camp H | 53139 | 3415 | 31.65 |
Camp I | 59105 | 3674 | 29.83 |
Camp J | 68719 | 17996 | 30.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?
Solved! Go to Solution.
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |