Forum Discussion

Baruch_Larionov's avatar
Baruch_Larionov
Regular Visitor
10 months ago
Solved

Dynamic Y axis on DateTime X axis

Hi, I'm new to Power BI. I learned how to get my data tables, and made some charts manualy draging x (DateTime) and y axis (Numeric columns). I tried to make a dynamicly y axis, using parameter wi...
Tutorial Requests
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 months ago

Hi,

If that is the structure of the raw data set, then in Power Query,  select the first 2 columns, right click and select "Unpivot Other Columns".  Now use Field parameters.

gsaluja's avatar
gsaluja
Frequent Visitor
4 months ago

Hi Ashish,

 

Thanks for the revert but the solution did not work.

 

Let me simplify my issue here.

 

The table above is the raw data.

 

I have simply plotted the graph based on above table on my power bi. (no query's or commands, just a simple plain visual graph).

 

However, I would like to filter my graph based on my selection from the pointers (highlighted in red) using a drop down slicer.

 

I tried creating the field parameter slicer but the graph comes out blank.

 

Im not a power bi trained professional.

 

If you can please help me in simpler terms to create the graph from the above table and having a drop down slicer with the pointers highlighted in red which I can select or unselect on my discretion.

 

Thanks in advance.

regards,

Geet Singh.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 months ago

    What have tried of my suggestion an where are you stuck?

    • gssaluja's avatar
      gssaluja
      New Member
      4 months ago

      Hi Ashish,

       

      Yes, I did try your suggested step.

       

      Table before - 

       

       

      After your suggested step - 

      & now when I go to create a new parameter, below are the options -

       

       

       

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        4 months ago

        In the Field parameter window, tick the Attribute box.

    • gssaluja's avatar
      gssaluja
      New Member
      4 months ago

      Hi Ashish,

       

      Yes I did tried your suggested step - 

       

      Table before your step - 

       

       

      Table after your suggested step - 

       

       

      Field parameter options post your step -