Variable column segmenter

[Syndicate_Admin]

I have a table with a column A and a column B. I want to create a new column C in that table. Column C would be the result of either column A or B depending on whether you choose option A or B in a segmenter.

How can I create a segmenter that allows me to do that?

[amitchandak · Accepted solution]

@Syndicate_Admin , You can not use slicer value in a calculated column,

You need think about dynamic segmentation or field parameters

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

or

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...