Show two histograms with different filters in the same visual

[hs248]

Hello,

 I have a table with one column "measurement" (with values A, B, C or D) and one column "value" (numeric). On my report page I have two identical slicers on the "measurement" column.

What I would like is two (binned) frequency distributions in the same visual, one each for the measurement value selected in each slicer. So the user should be able to select e.g. B in one slicer and D in the other and then compare the two frequency distributions in the visual.

Is this possible with a regular histogram visual? If yes, how would I set its filters?

Thanks in advance for any help!

[hs248]

@Deku You are right, a single slicer does the same job. Only in my particular case I have two slicers anyway. I need them to control other visuals on the report page independently of each other.

@danextian The histogram visual I was using was free and by Microsoft, but it seems now that it isn't available anymore. So I'll do dynamic binning along the lines of the pbix file you provided. Only I want to specify the number of bins instead of their size, but I'll get along from here onwards by myself.

Thanks for the contributions!

[danextian · Accepted solution]

Hi @hs248 

What is that regular histogram visual? There isn't one that is native. If it is a custom one, I would get in touch with the developer. Alternatively, as what others have suggested, use the cluster column chart. Attached is a sample pbix that uses that visual and bins the values dynamically.

[Deku]

Why not have a single single slicer.

You could use a cluster bar chart with measurement in the legend. This will show any number of histograms in the same visual. Alternatively you could use small mutliples.

If really want to use two slicers you will need to add another table, that is a distinct list of measurement and use TREATAS in a second measure. This is because both slicers would have to apply to the chart, and they would not be additive.

[hs248]

Hi  lbendlin, thanks for looking into this and sorry for the incomplete question. Here's a reduced version of what my table looks like:

Measurement	Value
A	1
A	2
A	2.5
B	0.5
B	1.5
B	2
C	1.5
C	2
D	0.5
D	1.5
D	2
D	2

Now I have slicer1 and slicer2 on my report page, both filtering the "Measurement" column. Suppose the user chooses B in slicer1 and C in slicer2, I want the histogram to look something like

If the user chooses C in slicer1 and D in slicer2, the visual shall look like

I created these example diagrams with fixed segmentation of the x axis (2 bins: 0 to 1 and 1 to 2), but I actually need a dynamic segmentation that adapts to the data. So I think I need a histogram visual.

Does this make sense? If it doesn't, feel free to ask for more explanations.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...