Forum Discussion

BenLyon's avatar
BenLyon
Frequent Visitor
1 year ago
Solved

Dynamic date axis

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

  • 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

5 Replies

  • HI BenLyon ,

     

    Can you provide more details here please?

    Also parameters are supported in Fabric.

     

    • BenLyon's avatar
      BenLyon
      Frequent Visitor

      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's avatar
        Pragati11
        Super User

        HI BenLyon ,

         

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

         

  • 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.

  • BenLyon's avatar
    BenLyon
    Frequent Visitor

    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