Forum Discussion
Filtering columns in stacked column chart
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.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
cmilligan262 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.
I would ❤ 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!
parry2k That worked perfectley. Thank you.
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.
cmilligan262 see the full explanation in the measure
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 ) )I would ❤ 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!
