Using Parameters with Non-Categorical Data

[WishAskedSooner]

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!

[danextian · Accepted solution]

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

[WishAskedSooner]

@danextian Thanks for the tip! The show values of selected field was what I needed!

[Akash_Varuna]

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