Dynamic measure in table

[sakshikaul]

Hi,

I have tried creating cyclic dimension in PBI using following approach

https://www.youtube.com/watch?v=lFd2hjkKz_Q

But still not getting the correct result in table.

Please help

[v-yuaj-msft]

Hi @sakshikaul ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file. I can do some tests for you.😊

Best Regards,

Yuna

[amitchandak]

@sakshikaul , Dynamic measure, and Dynamic Axis are two different codes.

Dynamic Measure -

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/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://www.youtube.com/watch?v=vlnx7QUVYME

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/