Forum Discussion

smazo's avatar
smazo
New Member
3 years ago

Unpivot Columns without duplicating data in Power Query

Hello dear colleagues:   I'm running into a unique problem with my large payroll dataset that is affecting how other numbers are calculated.    In short, I have a table that looks like this (this...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

smazo , Those all are measures you do need to break them, in case you need slicer, you can consider field parameters or calculations groups

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

 

If you want the split text in the name

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2