Forum Discussion
Create charts based on selected measure and fields
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.
4 Replies
- lbendlinSuper User
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 - RajsheisanFrequent Visitor
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 chThanks for your help.
- lbendlinSuper User
What happens when you plot your data with the standard line visual?
- RajsheisanFrequent Visitor
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.