Slicer issue !!

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.