Forum Discussion
Operation with a Selectedvalue
Hi !
Thank you for reading my message. I went through the forum but I didn't find the solution. I hope you'll help me !
I have the following type of dataset :
| brand | KPI 15-34 | KPI 25-49 | KPI W25-49 | KPI W 35-49 | KPI W 35-59 | KPI W 15-49 | KPI Wkids | Nb days |
| brand_1 | 241,20864 | 432,57426 | 469,30805 | 509,77522 | 683,14153 | 452,71012 | 412,66568 | 200 |
| brand_2 | 333,07644 | 576,55774 | 668,67969 | 724,99136 | 980,31178 | 658,07614 | 611,47355 | 183,9 |
| brand_3 | 917,0697 | 1523,15663 | 1781,4955 | 1940,31014 | 2648,86437 | 1750,07291 | 1623,26575 | 628,3 |
| brand_4 | 30,10922 | 53,17996 | 63,45236 | 64,96537 | 90,68875 | 61,97768 | 54,71776 | 50,3 |
| brand_5 | 409,0234 | 697,19137 | 811,0982 | 911,50668 | 1228,93875 | 797,87734 | 714,84962 | 396,8 |
| brand_6 | 927,98954 | 1579,8901 | 1827,26814 | 2056,94741 | 2729,62947 | 1804,56836 | 1650,93086 | 357,7 |
| brand_7 | 565,1796 | 972,69024 | 1125,04609 | 1264,98244 | 1756,49364 | 1111,69551 | 1007,85061 | 413,6 |
| brand_8 | 424,30876 | 727,18449 | 826,82702 | 889,24974 | 1076,72995 | 823,47158 | 740,32596 | 170,1 |
I have a slicer to select the KPI to display.
| KPI |
| KPI 15-34 |
| KPI 25-49 |
| KPI W25-49 |
| KPI W 35-49 |
| KPI W 35-59 |
| KPI W 15-49 |
| KPI Wkids |
I'd like to add, into a tab, the calculation KPI / Nb of days, depending on the selected KPI.
I've tried several formula, but I had an error each time.
Thanks a lot for your help !
Best regards,
MA
Hey,
You need to unpivot your data with Power Query befor working with slicers. More information you'll find here:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
5 Replies
Hey,
You need to unpivot your data with Power Query befor working with slicers. More information you'll find here:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098Yes, of course ! Thanks a lot
Can you share the expected output in the expected visual?
Hi Arul, thank you for your message.
I need this result (I added one metric - cost)
Hi Arul, i need this type of result (I have added one metric - cost) :
Hi Marieamelll ,
I wonder that you want to filter the table data by KPI type and you can check the result as below:
Go to Power Query, select all the KPI columns and click on unpivot columns and you get data like this:
Just save it and use the Attribute as a slicer.
Please feel free to correct me and provide more information if I have misunderstood you!
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
