Forum Discussion
Text parameter deciding which column (measure) to aggregate
Hello,
I am working on HR data.
I have employee+month level data which needs to be aggragated to produce metrics.
As far as I know Power BI does now faciliate text parameters.
I would like the end user to be able to select Headcount/FTE parameter which will give them total Headcount or FTE numbers based on their selection.
They also should be able to select the Data or Event type they are interested e.g. Headcount or Hires or Promotions and see the total Headcount or FTE for the selected data type.
I have followed the link below but it did not resolve my problem.
Many thanks for your help.
Anonymous , I think you are looking for a measure slicer
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEmeasure slicer using calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
1 Reply
- amitchandakSuper User
Anonymous , I think you are looking for a measure slicer
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEmeasure slicer using calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/