Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 D1...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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 🙂 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 🙂 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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. 

 

 

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you for the info. I would try this.