Forum Discussion

WishAskedSooner's avatar
WishAskedSooner
Continued Contributor
1 year ago
Solved

Using Parameters with Non-Categorical Data

Hi Experts,

 

I am trying to create a Line Chart with X-Y data and a Parameter and Slicer that allows the user to to flip between two different X-axis values. However, I can't seem to get it to work.

 

Do parameters only work for categorical data?

 

Thanks!

  • Hi WishAskedSooner 

     

    Field parameters work on both categorical and numerical data

    You might need to enable Show values of selected filed for it to work properly

     

     

3 Replies

  • Hi WishAskedSooner Parameters in Power BI can work with both categorical and numerical data for your Line Chart try this please

    • Create a parameter by going to "Modeling" > "New Parameter" > "Fields Parameter" and add the two X-axis fields you want to toggle between.
    • Add the parameter to a slicer, allowing the user to select which field to use as the X-axis.
    • Drag the parameter into the X-axis field of your Line Chart and add the Y-axis field as usual.
      If this post helped please do give a kudos and accept this as a solution
      Thanks In Advance
  • Hi WishAskedSooner 

     

    Field parameters work on both categorical and numerical data

    You might need to enable Show values of selected filed for it to work properly