topic Re: Primary Y axis and Secondary Y axis for same column value but for selective legend. in DAX Commands and Tips

Primary Y axis and Secondary Y axis for same column value but for selective legend.

ekunsom — Mon, 29 Apr 2024 12:29:21 GMT

I want to plot primary Y axis and Secondary Y axis for same column value but for selective legend. Legends at primary Y axis should be different than Secondary Y axis.

The plot should be like below which is possible in .xls

Re: Primary Y axis and Secondary Y axis for same column value but for selective legend.

Anonymous — Tue, 30 Apr 2024 01:19:08 GMT

Hi ekunsom

Hope the following document will help you solve your problem:

Customize X-axis and Y-axis properties - Power BI | Microsoft Learn

Best Regards,

Jayleny

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

Re: Primary Y axis and Secondary Y axis for same column value but for selective legend.

ekunsom — Tue, 30 Apr 2024 04:04:36 GMT

Hi Jayleny,

Thanks for your response.

My requiremnts is little bit different than the provided solution. Below is the input. I want to see few Object IDs in primary -Y axis and few at Secondary-Y Axis.

		X-Axis	Data to Visualize
Objective	ObjectId	RecordDate	Data Availability (%)
Primary- Y Axis	125400	01-01-2024	99.9
395000	01-01-2024	98.2
424000	01-01-2024	95.14
637668	01-01-2024	99.85
Secondary -Y Axis	cluster	01-01-2024	92.48

Regard

Somnath