Varience Column

[Anonymous]

Hi Team,

I need soluction for while selecting data expected Varience . highlighted in yellow.

expected in yellow colour,

Thanks,

KV's

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the pbix file:  https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EaT2fwMp5OlOncoPAjGlNq8Bp8uV6RJoAntw7Ev7SVP-Bw?e=HN9Eke

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Anonymous]

Hi @v-deddai1-msft ,

Thanks for your help,

It's working fine, however how can I implement dynamic filter like (Cycle --> 2020.05, 2020.04 or other value)

Thanks,

KV's

[v-deddai1-msft]

Hi @Anonymous,

You need to filter them in query editor and re-create index column for them. Please refer to the advanced editor in the pbix file above .The steps are similar to it.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai