Forum Discussion
Filtering and Slicers
I want to create reports for hormones in blood samples. Each sample has data such as the gender and age of the individual it came from. All of my data is in one sheet on a table. I currently have 2 panels, each with the same 4 slicers: sex, age class, sample season, and sample month. I want to create a gauge where by filtering on one panel, I can choose that categories that will sample. So say I want to see estrogen in geriatric males from winter. But I want to be able to change the markers of minimum, maximum, and target values to other fields. So maybe I want the samples of the geriatric males to be compared to samples from young females. Is this possible? I think I'm really just wondering if you can make 2 different slicer panels affect different parts of a single graphic.
I also want the min, max, and average markers to update based on the second set of selections.
So first you would filters samples and then you would choose what to compare those filtered samples to.
1 Reply
- parry2kSuper User
eedmondson Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490