Filtering columns in stacked column chart

Question

I'm wanting my column chart below to always display the actual scenario and then use the filter to compare it to another scenario. Let me know I need to clarify further. Any help is appreciated.

Thank you

parry2k · Answer

cmilligan262&nbsp;solution is attached, you have to create separate slicer to make it work, check solution where "A" is fixed, and compare against selected values in the slicer.
&nbsp;
I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
&nbsp;

edhans · Answer

You'll need to use ALL() or some variant to show Actual at all times, but yeah, we'll need more data to understand what you have and what you need. A link to a PBIX file in this case would be helpful plus a concise description of expected results. See links below.
&nbsp;
How to get good help fast. Help us help you.How to Get Your Question Answered QuicklyHow to provide sample data in the Power BI Forum

cmilligan262 · Answer

parry2k&nbsp;That worked perfectley. Thank you.&nbsp;Can you explain to me what this is doing. I need to apply it to a couple more YTD formulas and want to make sure I'm understanding it.

parry2k · Answer

cmilligan262&nbsp;see the full explanation in the measure
&nbsp;
&nbsp;
Measure = 
VAR __rows = 
DISTINCT ( --distinct will give us unique list of selected scenarios, it is required because if default scenario is selected in the slicer and we are also adding the default scenario in the UNION section, distinct will get us unique scenarios
    UNION (  --union will add default scenario with all the selected scenarios in the slicer
        CALCULATETABLE ( VALUES ( Slicer[Category] ), ALL ( Slicer[Category] ), Slicer[Default] = "Default" ), --get values for Actuals by looking at default column
        VALUES ( Slicer[Category] ) --get list of all the selected sceanarios in the slicer
    )
)
RETURN
CALCULATE ( 
    SUM ( Data[Amount] ),  --measure on which we want to apply the selected, it could be any existing measure
    KEEPFILTERS ( --keefilters to keep the row contet of the scenario
        TREATAS ( __rows, Data[Category] )   --treatus will be used to filter the scenarios
    ) 
)
&nbsp;
&nbsp;
I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Forum Discussion

Filtering columns in stacked column chart

4 Replies

Related content

Stacking Data Columns

Stacked Column Chart Data Labels

Need a stacked clustered column chart

Slicer for filtering several columns

Stacked Column Chart Data Limit Issue