Slicers not working with table created from measures

[msciarrino]

Hello Everyone,

I am calculating 4 different measures from 4 seperate data sources. I want to graph these measures in pairs of Baseline and Current. To do this, I created a new table that uses measures as values in the table.

Below is a sample of the data. Each numeric value is a seperate measure. The Tasks Column are manually input, Baseline and Current are calcualted columns using SWITCH and triggering off of the Task name to put the correct measure into the correct cell.

When I graph this data I get the picture below. This is exactly what I want my data to look like.

My problem comes in when I try to add a slicer. All of my baseline measures have a relationship to a date table. When I change the date from all to a specific day, I expect the baseline values to change on my graph, but they do not. When I use my slicer, the graph remains unchanged.

Is there a way to get the slicers to work with this graph? Is there a better way to create this graph that will get me the same layout and allow the slicer to work? I am not stuck to using this process, it was just something I tried but I cannot seem to find a solution that will make this work the way I want to.

Thanks for the help.

[Anand24]

Hi @msciarrino ,
Is there any relationship established between the table you pasted in your post and the date table? Your baseline and current values are not at the date level and hence the values aren't changing on slicer changes.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[msciarrino]

There is no relationship between the table and the date table currently. But I was assuming since the values that were populating the table had a relationship that the table values would update.

[Anand24]

@msciarrino ,
What's the relation? Can you please elaborate both tables and relationship.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[msciarrino]

The relationship from my measures to the table provided is by using the following to create the Baseline column in the table:

Baseline = switch('MeasureTable'[Tasks], "Task A", [MeasureA_Baseline], "Task B", [MeasureB_Baseline])

The relationship between the measure and the date table is through the source data table. There are dates in the source data table that align with my date table.

There currently no relationship between the Data source table and the table shown (With the exception that it is built based on measures from the source table) and no relationship between the date table and the table shown above.

I understand that the issue with the slice is related to not have a relationship between the date table and Measures table. The problem with adding dates to the measures table is that the dates would need to be dynamic enough to expand my table everytime a new date is added to the Data source table.