Forum Discussion
Dynamic slicing based on 2 different dimentions
If you add those fields (individually) to slicers, when you click on a geography or product category within the slicer, the data will be filtered. So lets say you have a line bar chart that has sales as the value and the x axis is month name. If you click on the geography slicer, the data that is aggregated in the bar chart will get filtered and the reflect the selected geography.
If you follow best practices of creating a star schema data model, then you should break out your geo and product dimensions into their own tables and creating relationships. Then, the only difference from what I described above will be (possibly) making sure that the relationships are bi-directional and that when you add a value to the slicer, it comes from the dimension table and not the fact table.
Hi Thansk for your reply.
I am advance user of tableau, and i am trying to see if there is some thing equivalent to tableau's parameter in power BI
Could you plese help me
- Add a slicer visual to your report and add the field you want to it (ie geography). Then add a different visual, like a table or chart, to display the sales value. Now when you click on a slicer value the data in the chart will update.
Your ask about parameters is different from your first question, and can be created in two different ways. If you want a parameter like a database connection string that can be changed by the user, you can create a parameter for that in the query editor. If you want a list of values that can be selected for something like a what-if analysis, you can make a table of all the incremental values, use this table/field in your slicer, and have whatever measures used to calculate the what-if scenario pull in the selected value.
Both of these are thoroughly documented online. Hi kesanasu,
Have you resolved the problem now? If so, would you please kindly mark the corresponding reply as an answer or sharing your resolution so that it can benefit more users? If you still have any question, please feel free to ask.
Regards,
Yuliana Gu
