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.
Hi
i have created one table with target details.xls and below are the information.
City Target
Chennai 90.4
Hyderabad 95.3
Mumbai 99.2
Delhi 93.5
Vizag 80.2
another table with
City sales Year month
Chennai 100000 2019-01
Hyderabad 234232 2019-01
Mumbai 345231 2019-02
Delhi 564323 2019-01
Vizag 45643 2019-02
I have data with another table with same city column along with that sales and yearmonth and i can able to map the city with sales along with target data table but target details are not changing dynamically when i take line & column bar chart.
Please support
Regards,
Rajendra
Hi
Resolved this issue:
By creating one more custom column, by merging the data from both the tables.
finally i have passed the target details in my primary table and written dax calculation based on target value generation in my first table.
reporting fine. Thanks
Regards,
Rajendra
Hi,
It is not very clear from the scenario explained. I have recreated the scenario in the form of pbix file
Please share more details, if this does not answer the problem.
Rgds,
Vivek
Hi Vivek- Thanks for your Quick support.
I have created one of the visual as below.
i was expecting target line should fluctuate based on year month field of X axis
the target line should be the value of 90.9,91.93,94,67,90.21,93.23 and so on.
it should not be the sum or average values to report.
For each of the month there is specific target values which that need to refer the graph as mentioned.
Please suggest.
Hi
Please find the attached sample data in sheet 1
i have target values with sitename in sheet 2
as per my attached snapshot given you in previous mail.
i was just expecting the target values should populate based on year month trend manner which is not coming in my way.
Please Suggest.
@vivran22 wrote:
Hi,
Is it possible to share the sample data table as well?
Rgds,
Vivek
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |