Line Chart X axis I have 2 Fields, I want to show the X Axis Label from only 1 field.

[sherifff]

Hello Community,

I have 2 fields, 

Date Field and Text Field called "Test Name".   Which i am using it in my X Axis and in the "Y" Axis i am using values. 

My Problem:

I want to show only the Date field in the Label for "X Axis"  Right now , I am getting both Date and the Test name combined together,

I followed some of the link from this community article to show the labels in 2 lines.  Which worked for me.

But What i am looking for is

I just want to show only 1 field which is "Date" field.

Can someone please help me on this. 

Thanks

[parry2k]

@sherifff not really sure what you want, why not remove "Test name" column form the x-axis and just keep date column?

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[sherifff]

Hi @parry2k ,

In my previous post i have given the field name as "Test Name" it was for each test. The correct X Axis field name is "Batch". 

This is the Graph i want to show (Please refer the 1st Screen Shot), But in a given dates if there are more than 1 test is done then it just adds up the values and shows the total value for "Actual Value" Field and also for "Min Value" If you look at the count in this case it is 3. Means i have 3 tests.  This is not what we want.  We want to show each of the test values seperately (Actual, Min, etc.,) I am not sure/ I don't know , if we can show the each test values separately.  So thats why i am using the 2nd Graph, where i am using 2 fields in the X Axis , 1 is "Lab Test Taken Date" and the 2nd is "Batch" Field.  The Batch Field has unique name for each of the tests for a given test name and Type based on year.   Example :  for 1/1/2021 ,  The Batch Field value is "NorCal_2021_001". In this way i am able to show the unique values , refer the below 2nd screen shot.

Screen Shot #1

2nd Screen Shot: In the below screen, The marked 2nd Field on the X-Axis should be hidden, It should not be visible.   As per requirement , it should just show the "Lab Test Taken Date"" Field value.  

I hope my requirement is clear.  

Here is my data details:

THanks for your help in advance!

[Mayank_Yavda]

Hi @sherifff ,

Here is Line Chart with Custom Label Based on Axis which will help you to get the axis as the data labels.

Line Chart with Custom Label Based on Axis, PBIVizEdit.com

Download link for the custom visual file in this page,

https://pbivizedit.com/gallery/line-chart-with-custom-label-based-on-axis 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

• anyone, irrespective of technical skills, can create their own visuals
• 15 minutes to create a visual from scratch
• opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

Thanks,
Team PBIVizEdit

[sherifff]

Hi @v-shex-msft @parry2k  or Any experts in this forum , 

Could you please provide your valuable input and let me know if this is something possible to achieve or not, so that i can stop investigating on this item.

Thanks for your time.

[v-shex-msft]

Hi @sherifff,

So you mean you want to show the full date field value on your chart without using the batch field?
If that's the case, you can use the date field on the chart axis and right-click on it to use general data mode instead of date hierarchy, then it will show the graph you wanted.

Regards,

Xiaoxin Sheng

[sherifff]

Hi @v-shex-msft ,

These are 2 fields,  1 is Batch Field and another is 2 one is  "Date" field ,   the Batch Field is a Text Field.        I guess you haven't get my issue correctly,    It is not the date hirearchy issue , I am using General Date ( i have already performed the step).

My issue is as of now i have to use both these fields in the X axis but i need to just show only the "Date" Field ,  Users don't want to see the Batch Details. 

any other suggestions please let me know

Thanks.