Filter and sclicer causing visualization discrepency
Hi I am a beginner in Power BI and I would like to know the feasibility/solution for my Queries. For a given data table "Prototype Modeling_freight" I have a measure as: volume = SUMX('Prototype Modeling_Freight', 'Prototype Modeling_Freight'[Sold Cases]) this converted to percentage for each type of equipment as: Volume distribution = DIVIDE([volume],CALCULATE([volume],ALL('Prototype Modeling_Freight'))),0) And visualized as clustered column chart Now there are specifically two things I want this chart to do: when I filter out through a date sclicer my chart must compare the data only within those sclicers, (note these sclicers can be other than dates) Eg: If you consider the Y axis in above picture, I want them to present 100%, or 'what was 25N's contribution in June month?'. Thank you
