Forum Discussion
How to add Dynamic Target line
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
5 Replies
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,
Is it possible to share the sample data table as well?
Rgds,
Vivek
