DAX

[Sowmiya]

Hi Community,
Help me with the DAX. 
This is my raw data in single table.


X-Axis vs Y-Axis is the required Bar Chart. Have given you what is X-Axis and What is in Y-Axis. This can be Done with DAX.




Date Slicer is Dynamic. When we change the date in filter, X-Axis and Y-Axis must change According. For sample, I have sliced date 2 times and Showed the Change in X-Axis and in Y-Axis.

Appreciating any response.
Thanks in Advance.
Ambhika

[v-yulgu-msft · Accepted solution]

Hi @Sowmiya ,

As we can only add columns onto chart X-axis, columns are static, which cannot be calculated conditionally based on slicer selection. For above output, it is not achievable now.

Regards,

Yuliana Gu