Forum Discussion
Help displaying data from different sources in one graphic
I have data from three different sources : municipalities, departments and regions (French geography).
I want the user to select different municipalities.
Then I would like to display one graphic showing :
- the aggregated data for all the municipalities selected (average, sum, or different calculations in function of the data) --> I have calculated measures in order to get those aggregated values
- the data for each municipality selected
- the data for the department of the selected municipalities
- the data for the region of the selected municipalities
- the data for the whole country
However, for the moment, I'm only able to display one graphic per item : one graphic for the agreggated municipalities, one for all the municipalities, etc...
For example, for unemployment : Aggregated municipalities (Nom de ma zone d'étude), Department (Nord), region (Hauts-de-France), France
Thank you for your help!!
1 Reply
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
