- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Duda with chart based on display table
Good morning
I'm new to this forum and relatively also with PowerBI.
I have some data in excel of this type that obeys a survey:
I need to create a report with a filter by country, a table, and a graph.
In the visualization table I must show for each city and district the mode, that is, for Ciudad_1 and Distrito_11 0 must come out Unsatisfactory, for Ciudad_1 and District _12 when there is a "tie" between 0 Unsatisfactory and 1 Improvable, 0 must come out which is the one with the lowest score between 0 and 1, and so for the others.
The chart should show the same as the display table, i.e., it should be based on the calculated mode measure and not on the data in excel. But I haven't managed to get the graph to show the same thing from the table, it's showing what's in the excel.
The "Score by City District" table correctly reflects the points fashion for each city and district.
But the graph "Evolution of the score by district and city" shows the values of the excel and not what the table Score by district city shows.
I think it's because the table is at the City-District level, while the graph is at the total level, but I don't know how to put the graph at the City-District level as well.
Please, could you help?
Thanks a lot
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Syndicate_Admin
Based on your information, I create a sample table:
You can create a new measure, try the following dax expression:
MaxScorePerDistrictMeasure =
CALCULATE(
MIN('Table'[PUNTOS]),
ALLEXCEPT('Table', 'Table'[Country], 'Table'[City], 'Table'[District])
)
Then create visuals and put fields in them, here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you for the help, it helped me to solve it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Syndicate_Admin
Based on your information, I create a sample table:
You can create a new measure, try the following dax expression:
MaxScorePerDistrictMeasure =
CALCULATE(
MIN('Table'[PUNTOS]),
ALLEXCEPT('Table', 'Table'[Country], 'Table'[City], 'Table'[District])
)
Then create visuals and put fields in them, here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-13-2024 03:20 PM | |||
07-26-2024 02:17 PM | |||
05-06-2024 07:44 PM | |||
08-12-2024 01:19 AM | |||
03-28-2024 03:38 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |