Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have tables as below and created measures for each tables.
first three tables belong to company M and next three with company IQ.
I wanted to display the measure in stacked bar chart as above with company name as category. how can we do that ??
Table name | Measure name |
M-IDMismatch | |
CountOfTableM-IDMismatch | |
M-NameMismatch | |
CountOfTableM-NameMismatch | |
M-NameMismatch | |
CountOfTableM-NameMismatch | |
IQ-IDMismatch | |
CountOfTableIQ-IDMismatch | |
IQ-NameMismatch | |
CountOfTableIQ-NameMismatch | |
IQ-NameMismatch | |
CountOfTableIQ-NameMismatch |
Solved! Go to Solution.
I created new columns mentioning each company name, and merged all tables. then i was able to add the data into stacked bar graph with catergory
I created new columns mentioning each company name, and merged all tables. then i was able to add the data into stacked bar graph with catergory
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
49 | |
42 | |
39 | |
38 |