Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Slice Facts based on UI events

Folks: I have a problem that I have recreated in the attached .pbix file.  This file contains only AdventureWorks data.   AdventureWorks data can be looked at based on OrderDate, DueDate or ShipDa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I got a little further.  rather then add a measure to FactInternetSales - I added a column.  Same formula as above - but now I do not need the min functions.  I can place the column on the axis - and my bar chart splits into multiple bars as I expect / want.

 

Now what the problem is - when I change the value in the UI slicer - the chart does not adjust.  Am I doing something wrong with selected value?

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
7 years ago

Calculated columns are populated and fixed at the time of data refresh. SELECTEDVALUE() won't help you there because of the fact that there will be no data refresh and recalculation of the column when the slicer changes.

 

I apologize for not understanding your use case (changing the axis of a visualization based on a slicer) - after re-reading it, what you are trying to do is not possible as far as I am aware. You could do something with buttons and bookmarks and hiding/showing visualizations, but not dynamically change the axis.

 

I will @ a few of the super users on here to see if they have any ideas

 

Greg_Deckler, AlB, any ideas?