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.
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.
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!
Hi @sherifff ,
Here is Line Chart with Custom Label Based on Axis which will help you to get the axis as the data labels.
Download link for the custom visual file in this page,
This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,
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).
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.
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
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!