cancel
Showing results for
Did you mean:
Helper IV

## Histogram based on a filter

Hi,

I would like to create a histogram as below :

Here are the data

 Name Group Sub-group A1234 W123 AAA B1234 w123 AAA C1234 w456 AAA D1234 w456 AAA D1234 w789 AAA D1234 w789 AAA D1234 w456 AAA E1236 w789 AAA E1238 w456 AAA A1236 w789 BBB A1237 w123 BBB D1237 w456 BBB D1235 w456 BBB E1237 w789 BBB E1239 w456 BBB B1236 w789 CCC B1237 w123 CCC E1234 w789 CCC E1235 w123 CCC A1235 w123 DDD B1235 w456 EEE C1235 w456 FFF C1237 w123 III C1236 w789 UUU

Could you please advise how I could exclude the Name where the Sub-group has only 1 Name:

For example :  the following Name should be removed from the histogram

 Name Group Sub-group A1235 w123 DDD B1235 w456 EEE C1235 w456 FFF C1237 w123 III C1236 w789 UUU

1 ACCEPTED SOLUTION
Solution Supplier

Hi,

You could create a new column like this:

And then use that new column as a filter for the visual and exclude when value is less than 2. Or inlude only those that are greater than 1:

I hope that helps 🙂

4 REPLIES 4
Solution Supplier

Hi,

You could create a new column like this:

And then use that new column as a filter for the visual and exclude when value is less than 2. Or inlude only those that are greater than 1:

I hope that helps 🙂

Helper IV

Thank you.

Here is the DAX I use :

= Calculate(DISTINCTCOUNT(Table[Name]), FILTER(Table, EARLIER(Table[Subgroup]) = Table[Subgroup]))

However, I find out that there are many "null" values in the column Sub-group.

How could I compare the sub-group column which is in another table that has relation to this table?

I do something similar for the Matrix , then filter the value > 1.

But for the histogram, I can't do this filter.

Solution Supplier

I am not sure what you are trying to do with the null values.

Would you want to use something like this? https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

Does the other table's sub group have null values as well?

Helper IV

Thank you for the info. I would try this.

Announcements

#### Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors