Dynamic Y axis on DateTime X axis

[Baruch_Larionov]

Hi,

I'm new to Power BI.

I learned how to get my data tables, and made some charts manualy draging x (DateTime) and y axis (Numeric columns).

I tried to make a dynamicly y axis, using parameter with no success. According to some youtube videos...

parameter:

Y axis = {

    ("param1", NAMEOF('db'[param1]), 0),

    ("param2", NAMEOF('db'[param2]), 1),

    ("param3", NAMEOF('db'[param3]), 2),

    ("param4", NAMEOF('db'[param4]), 3),

}

Then I out the "Y axis" on the Y axis of the chart.

What methos should I use?

[Praful_Potphode]

Hi @Baruch_Larionov ,

for dynamic y axis, you have to first create measures and use them in field parameters.

Please find sample pbix file for reference.

Dynamic Y Axis 

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[Baruch_Larionov]

Thank you for your solution.

It is working, but I have about 200 parameters that i want to dynamicly view.

I want to create a dynamic chart for some industrial facility with big amount of sensors.

Making calculation for every parameter is not efficiat for me.

[Praful_Potphode · Accepted solution]

Hi @Baruch_Larionov ,

you can create all 200 measures in one shot using c# and tabular editor.

please refer below link for more information

https://docs.tabulareditor.com/te2/Useful-script-snippets.html 

Tabular Editor comes handy for creating bulk measures with similar definition.

Thanks and Regards,

Praful

[Baruch_Larionov]

Thnak you for your help

[Arul]

@Baruch_Larionov ,

Please share the sample data and the chart that you are looking for, it would be helpful.

[Baruch_Larionov]

https://drive.google.com/drive/folders/1ptLnRTYnXZG3o_hCqQVZ9Cj2ZR5zG5vc?usp=sharing

[amitchandak]

@Baruch_Larionov , Create field Parameter using the field option in parameter 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
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
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw