Forum Discussion
Compare Data at multiple level
I'm in the requirement gathering phase. Solution we are looking for is to compares sales by mutilple slicer.
Step 1: User Select Region for Slicer#1 then User Selects another Region from Slider#2 to Compare the sales between selected region
Step 2: User Selects Vendor from Slicer#3 then User Selects another Vendor from Slicer#4 to Compare sales by vendor
So at a very high level I would like to first compare sales by region and then within those regions sales by vendor.
I hope this helps.
Hi,
There should be 1 slicer for all Regions and another slicer for all vendors. Why would you want to have 2 slicers for Customers and another 2 for vendors?
Ashish_MathurThere are 6 different fields to compare Region, Country, Vendor, Product, Supplier, Customer * 2 = 12
We want user to compare Region with another region and so on.
Hi,
You still do not need 2 slicers for each. If you drag Region to the column or section and also have a slicer, then when you select a specific region from the Region slicer, only those 2 regions will be visible in the visual.
How would that give me variance between multiple selections?
Region 1 Total - Region 2 Total and etc.