Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Thank you in advance.
Solved! Go to Solution.
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 🙂
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 🙂
Thank you.
Here is the DAX I use :
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.
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?
Thank you for the info. I would try this.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |