Forum Discussion
WishAskedSooner
1 year agoContinued Contributor
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!
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
- Akash_VarunaSuper User
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
- danextianSuper User
Field parameters work on both categorical and numerical data
You might need to enable Show values of selected filed for it to work properly
- WishAskedSoonerContinued Contributor
danextian Thanks for the tip! The show values of selected field was what I needed!