Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I am having a data which have only two values Staff or Temporary

At present I am having only one entry as below

enter image description here 

All I need to show is Staff with it its value on the Y-Axis

and when I plot it only shows as Staff in the column

enter image description here

How can I resolve it?

1 Answer

0 votes
by (22.5k points)

Create a lookup Table that can use the relationships in the examples you are using the following two tables:

Employee Data

enter image description here

Employee Type

enter image description here

and create a relation between them

enter image description here

Want to learn more about Power BI? Check out today: Power BI course  

Related questions

0 votes
1 answer
asked Feb 21, 2021 in BI by Chris (11.1k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...