Assuming I have a "Store Name" slicer made from 'General Info'[Store Name] and a random store name is selected, I'd like to use the following 3 tables:
General Info (has all store names)
to create a measure/calculated column that can be used in a Stacked Column Chart where:
Value: The selected Store's corresponding Global Sales & W Sales
Legend: "Global Sales" ; "W Sales"
The chart displays only 1 Store's sales data and if no Store is selected from the "Store Name" slicer, leave the chart blank
Is there a way to concatenate Global Sales & W Sales into the same graph all the while showing only 1 Store at a time? It looks like an easy task, however, I can't seem to find a way to run both Global Sales & W Sales under the same graph. My graph would always have multiple Stores instead of 1 if I didn't make any selection in the "Store Name" slicer.