Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two different sets of Data (1. Payroll cost 2. Demographic).
I am trying to create a table showing dept. no of headcount. average cost.
Example.
Department (From Bridging Table) | Headcount (From Demographic) | Average Employment Cost (From Payroll Cost) |
Human Resource | 2 | 100 |
Finance | 10 | 150 |
Customer Service | 5 | 120 |
I have created a bridging table for Department by creating a table based on the distinct value of Department in the demographic table. Relationship is one to many single direction from Demographic["Department"]to bridging table["Department"] and one to many single direction from payroll["Department"] to bridging table["Department"].
However, when i create visualization it is always showing all departments despite not having any data for headcount and average employement cost.
Example (on this month, there are no cost and no headcount in finance department, yet "Finance" is still reflected in the Department column.-show item with no data is not selected)
Department (From Bridging Table) | Headcount (From Demographic) | Average Employment Cost (From Payroll Cost) |
Human Resource | 2 | 100 |
Finance | 0 | 0 |
Customer Service | 5 | 120 |
Ideal State with the scenario.
Department (From Bridging Table) | Headcount (From Demographic) | Average Employment Cost (From Payroll Cost) |
Human Resource | 2 | 100 |
Customer Service | 5 | 120 |
Please Advice.
Thank you.
Solved! Go to Solution.
@Anonymous , need to look at the formula, is converting blank to 0. Ideally, it should be blank where there is not data
Are you using like
Meausre = count(Table,Table[A]) +0
Or using this option
Another option is filter 0 using visual level filter
@Anonymous , need to look at the formula, is converting blank to 0. Ideally, it should be blank where there is not data
Are you using like
Meausre = count(Table,Table[A]) +0
Or using this option
Another option is filter 0 using visual level filter
Hi @amitchandak, thanks a lot it work. I was using measure = +0 , i removed the +0 and the unnecessary information is gone.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |