Forum Discussion
Slicer issue !!
I want to show the data tertial and year wise in single visual bar chart by using slicer but data is in single field parameter column , How to show that ?
Filed Parameter Column below
Hi anjanikumar
In your case, you’ve already created a field parameter table where both Tertial and Year are stored in a single column (Category Selection Tertial Order) with an additional flag column identifying whether a row belongs to “Tertial” or “Year.” When you place this field parameter in a slicer, Power BI will let the user switch between views, but it won’t automatically combine both Tertial- and Year-level data in the same bar chart. To achieve that, you need to configure the visual so that the field parameter drives what axis is displayed. Essentially, you’ll put the field parameter (Category Selection Tertial Order) on the X-axis of your bar chart and use the slicer (linked to the same field parameter) to let users choose whether they want to see the data by Tertial or by Year. Behind the scenes, Power BI will dynamically switch the axis depending on the slicer choice. If you also want the ability to show both levels in a single visual at the same time (rather than toggle), then you should instead create a proper hierarchy (Tertial → Year) in your model or duplicate the measures and fields into a union table, rather than using field parameters. In short: field parameters allow you to switch between Tertial and Year in the same visual using a slicer, but if your goal is to combine them together, you’ll need a hierarchy or a custom dimension table that maps both levels in one structure.
8 Replies
Hi, could you provide some more details and maybe use Excel or PowerPoint to "draw" a desired result?
This should help us to help you 😉Hi anjanikumar ,
When you refer that you want to show the values in a single visual bar chart what do you mean? you want to have a category for each one?
Place this Flag column from the Field parameter on the legend or on Y-axis values after the parameter value this will categorize your values for each one of those columns.
If this is not what you are looking for can you please provide a sample data.
If you want to toggle between Tertial and Year → use your Field Parameter in Axis + same Field Parameter in Slicer.
If you want to see both together → create a union table (Tertial + Year) and use that as Axis, with Flag as slicer.
Hi anjanikumar,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Shahid12523, MFelix, & Sergii24 ,Thanks for your prompt responseThank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community supportCreate a new Field Parameter for tertial and use it in slicer
anjanikumar, We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community supportHi anjanikumar
In your case, you’ve already created a field parameter table where both Tertial and Year are stored in a single column (Category Selection Tertial Order) with an additional flag column identifying whether a row belongs to “Tertial” or “Year.” When you place this field parameter in a slicer, Power BI will let the user switch between views, but it won’t automatically combine both Tertial- and Year-level data in the same bar chart. To achieve that, you need to configure the visual so that the field parameter drives what axis is displayed. Essentially, you’ll put the field parameter (Category Selection Tertial Order) on the X-axis of your bar chart and use the slicer (linked to the same field parameter) to let users choose whether they want to see the data by Tertial or by Year. Behind the scenes, Power BI will dynamically switch the axis depending on the slicer choice. If you also want the ability to show both levels in a single visual at the same time (rather than toggle), then you should instead create a proper hierarchy (Tertial → Year) in your model or duplicate the measures and fields into a union table, rather than using field parameters. In short: field parameters allow you to switch between Tertial and Year in the same visual using a slicer, but if your goal is to combine them together, you’ll need a hierarchy or a custom dimension table that maps both levels in one structure.
May I ask if you have resolved this issue? If so, Can you please share the resolution steps here. This will be helpful for other community members who have similar problems to solve it faster.
If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.
