Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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.
What happens when you plot your data with the standard line visual?
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.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
2 |