Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi.
I am currently using the Line and Cluster Column chart within one of my reports (see below). Ideally I want the Line element of this chart to show discrete values only and not a continous line.
For each grouping in the chart (can be seen by the green/black/red bars) on the second Y-axis I want to plot a discrete value so effectivly only one plot per grouping. This chart joins the discrete points into a line.
I aprreciate that this chart is designed to work this way, does anyone know of any other available visuals which would allow me to do what I want?
Hi @dax_bee,
>>For each grouping in the chart (can be seen by the green/black/red bars) on the second Y-axis I want to plot a discrete value so effectivly only one plot per grouping. This chart joins the discrete points into a line.
Did you want to switch the same color bar to one group, right?
If this is a case, you can try to exchange the Shared axis and Column series fields of "line and clustered column chart".
Regards,
Xiaoxin Sheng
Hi Xiaoxin
Ideally I am looking for a chart which will generate the following. The line being replaced by discrete points (in this example triangles)
Hi @dax_bee,
>> The line being replaced by discrete points (in this example triangles)
I think the issue may related to your formula which store on the line value, it not appeared on my side.
Regards,
Xiaoxin Sheng
Hi Xiaoxin.
There may be a little confusion here. Ideally I am looking for a chart which displays both Chart & discrete points (not line). If as per your comments you feel you have an example of this please post an image.
Thanks.
Hi @dax_bee,
Sure, below is my sample file:
Source table:
Table = ADDCOLUMNS(CALENDAR(DATE(2016,1,1),DATE(2016,12,31)),"Month",FORMAT([Date],"mmmm"),"Day",FORMAT([Date],"dddd"),"Amount",RANDBETWEEN(0,100))
Notice: I add the filter to filter first three months, the line value is the average of amount.
Regards,
Xiaoxin Sheng
Hi Xiaoxin.
Appreciate the update, but as per my previous comments the requirement is a bar chart + discrete points on a seperate Y-axis. Your solution is currently acheivable with the out of the box "Bar & Line chart".
If you re-read the thread this may provide you with greater clarity as to the issue I have.
Thanks.
Not aware of one. You will probably have to do some kind of R visual to get what you want.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |