Only Time on X-Axis when "1D" is selected, and dates for the remaining options like 1W, 1M, 6M, 1Y

[wahidsyed2728]

Hi Gurus,

I've a requirement to select any of the options like "1D", "1W", "1M", "6M", "1Y", "2Y", "Max", and "Custom", where "Custom" refers to the Custom Date Range Selection. 

Based on the above selection options, if an user clicks on the option "1D", my x-axis of the line chart shall display only TODAY's time (24hrs or the time wherever the data is available to be displayed), and for the rest of the options, it should display the corresponding dates. For the "Custom" selection, a "Date" slicer shall appear and based on the dates selected, the respective Time if it is 1 day, or Dates if it is not 1day shall be displayed over the x-axis. I'm struggling to show the time on the X-Axis, have been trying lot of things, but did not work out.

Need help.

Thanks,

Syed

[wahidsyed2728]

Hi Ibendlin,

We are developing something similar to the snapshot I've attached. Please check the same and lemme know.

Link: https://www.investing.com/indices/us-30-futures-chart?cid=1175152

Thanks,

Syed.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

Consider using a datetime value for the X axis and eschewing the whole options thing. Then use zoom sliders to hone in on the period you need.  The visual will automatically change the tick values.

There's also a custom visual called timeline slicer. might be worth a look.

Be aware that the cardinality will be very highe especially if you go down to second level details.

[wahidsyed2728]

Hi lbendlin,

It did not work out for me. Looks like controlling the slicer has to be done explicitly using the parameters. Any idea over that will be of great help.

Thanks,

Syed.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...