Regarding Dynamic Y axis

Question

Hi ,I have 3 columns1.start date2.effort hours3.durationi want to display graph using stacked column chartsample data :start-date duration&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;effort required18-08-17&nbsp; &nbsp;0 00:07:31.514773&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1019-08-17&nbsp; &nbsp;0 00:01:48.569579&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 920-08-17&nbsp; &nbsp;0 00:06:17.669223&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 821-08-17&nbsp; &nbsp;0 00:05:18.844028&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1022-08-17&nbsp; &nbsp;&lt;null&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 923-08-17&nbsp; &nbsp;&lt;null&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 923-08-17&nbsp; &nbsp;&lt;null&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1024-08-17&nbsp; &nbsp;0 00:06:32.708942&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 625-08-17&nbsp; &nbsp;0 00:06:48.683115&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 226-08-17&nbsp; &nbsp;0 00:01:00.933775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1427-08-17&nbsp; &nbsp;0 00:03:16.847788&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1020-08-17&nbsp; &nbsp;0 00:06:17.669223&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;821-08-17&nbsp; &nbsp;0 00:05:18.844028&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1026-08-17&nbsp; &nbsp;0 00:01:00.933775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1427-08-17&nbsp; &nbsp;0 00:03:16.847788&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10requrement:X-axis: start datey-axis: should display duration and effort, based on slicer selection if we select duration it should should display start-date on x-axis and duration on yaxis ,if we select effort it should display start-date on x-axis and effort on y-axis.Please help meregardsRavichadnra JL

v-juanli-msft · Answer

Hi&nbsp;ravichandra0788
To display dynamic Y-axis, you need to modify the dataset by "Unpivot columns".

Then add the "Attribute" to the slicer, "value" to the Y-axis, However, the "Value" filed of the stacked column visual should be in number type, but "value" column above is of text type.
&nbsp;
Best Regards
Maggie

Forum Discussion

Regarding Dynamic Y axis

1 Reply

Related content

Dynamic Axis Relabelling

dynamic x-axis based on filter

Query Regarding Dynamic Queries

dynamic x axis

Dynamic Y axis on DateTime X axis