Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I heard about how PowerBI doesnt support dynamic variables in calculated Columns, so I wanted to ask if anyoe else had a workaround.
Basically, I have a very simple table with two columns.
1 is Project Name, and 2 is Sales.
My intended endpoint
I want to summarise my tables based on a slicer. Anything with over [x] revenue (determined by slicer) will show Project name. Anything below will be grouped together under "Missed threshold", or "no revenue" or "negative revenue"
My current method
1. Create calculated column:
Issue: The calculated column does not update when I move the slicer as PowerBI does not support that if i recall correctly. Does anyone have a workaround that would allow me to move a slicer, and have the table automatically group revenues that are below 10m into a separate bucket, leaving only the project names of those that meet the criteria showing separately?
Thanks so much!
Hey,
unfortunately what you want to achieve is by no means simple, but nevertheless, there are well documented approaches ...
I recommend starting with this excellent blog: http://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/
Regards,
Tom
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |