Always show certain data in a Graph despite slicer selection

Question

I have the situation where in one table both Savings and Targets are stored (data structure below). I want to have a graph with on the x-axis the years, and on the y-axis the Savings (bar) Target (line).The solution I have in mind is:- Two slicers: one for "BG", one for "Plant"- The result (table or graph)&nbsp; should&nbsp;always&nbsp;display the target records despite the value of the slicer.&nbsp;&nbsp;Data StructureBG&nbsp; &nbsp; &nbsp; &nbsp; | Plant&nbsp; &nbsp; | Saving | Target | year------------------------------------A1&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; B1&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;200&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp;| 2023A 2&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; B2&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;200&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp;| 2024etc.Target&nbsp; |&nbsp; Target&nbsp; |&nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; 105&nbsp; &nbsp;| 2023Target&nbsp; |&nbsp; Target&nbsp; |&nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; 205&nbsp; &nbsp;| 2024&nbsp;What I did already&nbsp;First, for the slicers I made a separate table using DAX storing the BG and Plant. This table (called "Table1") has no relation with my main table&nbsp;category list =SELECTCOLUMNS(&nbsp; &nbsp;&nbsp;Table1,&nbsp; &nbsp;&nbsp;"BG",Table1[BG],&nbsp;"Plant",Table1[Plant])Second:&nbsp;Added a measure to my main table. If the value for the plant record is "Target" the 1 otherwise 0. This this for both the "Plant" and "BG" field.&nbsp;is filter_plant =if(&nbsp; &nbsp;&nbsp;MIN(Table1[Plant]) =&nbsp;"Target"&nbsp;,&nbsp; &nbsp;&nbsp;1,&nbsp; &nbsp;&nbsp;if&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MIN(Table1[Plant])&nbsp;IN&nbsp;VALUES('category list'[Plant]) ,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;1,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0&nbsp; &nbsp; )ResultIn the slicer (via category list), "BG=A2", the the table looks like below. Which is acutally great, since now I can filter on "filter_plant=1" and "filter_bg=1" and the table will show the perfect and desired resultBG&nbsp; &nbsp; &nbsp; &nbsp; | Plant&nbsp; &nbsp; | Saving | Target | year | filter_plant | filter_bg--------------------------------------------------------------------A1&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; B1&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;200&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp;| 2023&nbsp; |&nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; 0A 2&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; B2&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;200&nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp;| 2024&nbsp; |&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; 1etc.Target&nbsp; |&nbsp; Target&nbsp; |&nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; 105&nbsp; &nbsp;| 2023 |&nbsp;&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; 1Target&nbsp; |&nbsp; Target&nbsp; |&nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; 205&nbsp; &nbsp;| 2024 |&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; 1The problemWhen i create a "line and clustered column chart" out of the table above, the result is good when no data is selected via the slicer. Once selected via the slicer, the graph is empty. How to solve?

amitchandak · Answer

IwanVB , Try like 
&nbsp;
Countrows(filter(Table1, Table1[Plant] IN VALUES('category list'[Plant]) || Table1[Plant] = "Target"))+0
&nbsp;
&nbsp;
or
&nbsp;
Switch(True(),max(Table1[Plant]) IN VALUES('category list'[Plant]) || max(Table1[Plant]) = "Target", 1,0)+0

Forum Discussion

Always show certain data in a Graph despite slicer selection

1 Reply

Related content

Power BI Import Mode Fails with Cross-Warehouse Views Despite SELECT Permissions

Need DAX Measure to Always Return Constant Result Despite Page Level Filter selection

Super long refresh times despite incremental refresh

Duplicate total despite the filter used

Power BI Desktop reads messages aloud despite Windows Narrator being disabled