Forum Discussion
Default Slicer Value from Matrix
Hello all. I have areport I'm building to show shortages. I am tracking quantity on hand and days on hand across an enterprise and at a local level. I have a matrix that shows the 5 items with th...
That's not exactly what I'm doing. Apologies for not being clearer. My slicer has all the medications I am tracking. My matrix has the top five with the lowest days on hand. My goal is for the slicer to default to the top number in that matrix so all other visualizations on the page (that are subject to the filter from the slicer) start on that view. Otherwise my graphs show days on hand for all products, which is meaningless.
Here's the matrix:
Based on that, I'd like my slicer to default to heparin. If metronidazole slipped below that in terms of days on hand and became the top problem, then that would be the starting point on the slicer when the report was opened. This will be host on SharePoint, if that makes any difference.