Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
xinxin63
Frequent Visitor

No Column Names Show for Lines (in a combo chart) in 'Show Data'

Hi, I am making a combo chart and there are multiple lines in the chart. When I click show data in the top right of my visual, there is no column names showing in the table.

Here is the visual:

Screen Shot 2018-10-08 at 11.28.57 AM.png

 

This is my selection panel:

Screen Shot 2018-10-08 at 11.28.46 AM.png

 

And this is the show data table:

Screen Shot 2018-10-08 at 11.29.24 AM.png

As you can see, there is no column names for my lines. Anyone has idea what's going wrong? Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@xinxin63,

 

I don't have any way in my mind that can show those columns label with the combo chart and using line. Howerver, you can use different formating or put a table below to clarify the data:

 

One of my solution:

 

1.PNG

 

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

@xinxin63,

 

It looks like your column name referring to the DemoFacility-73, which doesn't show up in the table? It will be clearer if you can provide me with the sample data. Thanks.

 

Duc

YearQuarterMonthFacility25th Percentitle75th PercentitleMedianColumn 1
2017Qtr 1JanuaryDemoFacility-731.487810133.391525182.252435071.17008829
2017Qtr 1FebruaryDemoFacility-731.211482682.707785731.868925941.1118973
2017Qtr 1MarchDemoFacility-731.365001373.103838372.076933461.72169334
2017Qtr 2AprilDemoFacility-731.204738952.760577241.901743271.80159892
2017Qtr 2MayDemoFacility-731.199113613.04647441.691093571.35025655
2017Qtr 2JuneDemoFacility-731.148166332.995970031.855287572.23388808
2017Qtr 3JulyDemoFacility-731.088330422.953306411.756474152.46029971
2017Qtr 3AugustDemoFacility-731.169639042.883877871.917545541.40745954
2017Qtr 3SeptemberDemoFacility-731.154734412.56191291.72525341.96099793
2017Qtr 4OctoberDemoFacility-731.190948792.96076981.742497582.02342918
2017Qtr 4NovemberDemoFacility-731.16563832.634018211.808318261.81591193
2017Qtr 4DecemberDemoFacility-731.372099062.950667352.043703821.3735006

 

Column Names for lines that repersent median, 25th and 75th percentiles didn't show in the 'show table'. Column 1 is the value for bar, facility is the value for bar series. Thanks.

Anonymous
Not applicable

@xinxin63,

 

Got ya, the reason why your data table of the visualization doesn't show header for 25th, 75th and median is that those are aggregated columns.

 

If you are trying to represent the data table next to the chart, I recommend to create a table. 

 

Otherwise, if you still want to show all these column header in data table, you will have to unpivot the columns.

In Power Query, select columns 25th, 75th, Median and Column 1 then Transform -> Unpivot Columns:

 

1.PNG

 

Then you can import and create visualization as follow:

 

2.PNG

Hi Duc,

Thank you for replying. What I would like to see is a combo chart (bar and lines together). So that it will be very clear that whether demofacility76 is below or above those percentiles. Instead of showing all of them in bars, is this possible to show the combo and show those line names in 'Show Data'?

Anonymous
Not applicable

@xinxin63,

 

I don't have any way in my mind that can show those columns label with the combo chart and using line. Howerver, you can use different formating or put a table below to clarify the data:

 

One of my solution:

 

1.PNG

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.