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 am creating visuals where my main data table is referencing several lookup tables. For example, here is a portion of my main data table with values under reportingCategory. There is a Many to One relationship between this main table...
...and the lookup table:
I want to display the Student Group value from the lookup table in my tooltips. So for my column chart, for example, each column is displaying data from one row of my main data table.
Yet the tooltip looks like this:
The "First" should not be there in my mind, because only one value is being returned. When I select Count to confirm this, here is what I get:
Here is the relationship between the two tables:
The "First" is going to confuse my users. Why is it there?
Solved! Go to Solution.
firstly 🙂 if you change your bar chart to a matrix, does it give you more than one first?
you can also double click on the label where it says first and rename it. Its just a standard really because its categorical data and you are aggregating your data, regardless of whether there is 1 or more.
Proud to be a Super User!
firstly 🙂 if you change your bar chart to a matrix, does it give you more than one first?
you can also double click on the label where it says first and rename it. Its just a standard really because its categorical data and you are aggregating your data, regardless of whether there is 1 or more.
Proud to be a Super User!
I HAD NO IDEA YOU COULD CLICK AND EDIT THIS!! Thank you 🙂
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |