topic Create charts based on selected measure and fields in Developer

Create charts based on selected measure and fields

Rajsheisan — Fri, 17 Jun 2022 01:47:20 GMT

Hi,

I am trying to create charts (it could be a bar or line chart) in just one bucket based on a selected measure and field/s values from a table. Would any one healp me on this please.

Thanks in advance.

Re: Create charts based on selected measure and fields

lbendlin — Sun, 19 Jun 2022 21:07:43 GMT

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Create charts based on selected measure and fields

Rajsheisan — Sun, 19 Jun 2022 23:50:30 GMT

Hi Ibendlin,

Thanks for the response.

group_name	Date	group details	Month_Target	Current_Month	FYTD	LYFYTD
A	2022-06-18	A-1	100%	100.00%	93.18%	91.69%
A	2022-06-29	A-1	100%	90.00%	93.18%	91.96%
A	2022-06-18	A-1	80%	100.00%	93.18%	91.69%
A	2022-06-29	A-1	80%	85.00%	93.18%	91.96%
A	2022-06-18	A-1	85%	100.00%	93.18%	91.69%
A	2022-06-29	A-1	85%	100.00%	93.18%	91.96%
A	2022-06-18	A-1	90%	100.00%	93.18%	91.69%
A	2022-06-29	A-1	90%	100.00%	93.18%	91.96%
A	2022-06-18	A-1	95%	80.00%	93.18%	91.69%
B	2022-06-29	B-1	95%	90.00%	93.18%	91.96%
C	2022-06-12	C-1	100%	75.00%	57.75%	61.47%
C	2022-06-16	C-1	100%	60.00%	57.75%	61.40%
C	2022-06-25	C-1	100%	90.00%	57.75%	61.52%
C	2022-06-12	C-1	80%	90.00%	57.75%	61.47%

for th eabove table, when someone clicked on any of the row the selected Month_Target and Current month data should be shown in a chart for the particular date as well as drill thru data for a given month. I have a calendar table with all required details.

The output of the chart should show Month_Target against Current month values for a particular date and the month selected. The ch

Thanks for your help.

Re: Create charts based on selected measure and fields

lbendlin — Mon, 20 Jun 2022 01:50:19 GMT

What happens when you plot your data with the standard line visual?

Re: Create charts based on selected measure and fields

Rajsheisan — Mon, 20 Jun 2022 02:35:22 GMT

Thanks again,

I managed to get the line chart as shown above using month_target and current_month (actually it is day) averages but, still a bit confused as I suspect the day values are shown per each group is lesser.