cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rajendraongole1 Regular Visitor
Regular Visitor

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

5 REPLIES 5
vivran22 Member
Member

Re: How to add Dynamic Target line

@rajendraongole1 

 

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

rajendraongole1 Regular Visitor
Regular Visitor

Re: How to add Dynamic Target line

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.

 

image.png

 

 

vivran22 Member
Member

Re: How to add Dynamic Target line

Hi,
Is it possible to share the sample data table as well?

Rgds,
Vivek
rajendraongole1 Regular Visitor
Regular Visitor

Re: How to add Dynamic Target line

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
Spoiler
 

 

Highlighted
rajendraongole1 Regular Visitor
Regular Visitor

Re: How to add Dynamic Target line

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

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 432 members 4,434 guests
Please welcome our newest community members: