Dynamic date axis

[BenLyon]

Hello,

I want to have a dynamic date axis whitch gonna be change about the format according to the date interval selected in a segment.
I know a solution in power bi but i have to use a parameter i unfortunately i thing they can not be use in fabric yet.

Thanks

[BenLyon · Accepted solution]

Hello ,

You can use parameters when you are in import mode and when you use desktop.

I made a calendar hierarchy 

Thank you all of you

Ben

[danextian]

If you are talking about dynamically changing the format of a date, you can't do that with columns. You can set the format at the semantic model or visual level but not dynamically. There maybe workarounds using disconnected table but I bet they will be tricky to handle. Alternatively, you can  use field parameters to switch between different date elments like year, month or quarter or another date column with a different format.

[Pragati11]

HI @BenLyon ,

Can you provide more details here please?

Also parameters are supported in Fabric.

[BenLyon]

Hello @Pragati11

How can i create a parameter when you go to modeling in Desktop i can not create a parameter.

I need to create a table with dax to but i think it is the same way.

Ben

[Pragati11]

HI @BenLyon ,

When I say parameters for handling dynamic date axis, I mean field parameters.