cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V

## 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 V

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 V

Thank you for the info. I would try this.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors