Forum Discussion
Empty line chart
Hello!
I have a simple query:
- Id
- Date
- Value
and two visuals:
1. Table with aggregated Value (max, sum, avg, etc, it doesnt matter) by id. smth like that:
- Id
- Calculate(MAX(MyQuery[value]))
2. Line chart with date as X-axis and "Value" as value
When user opens the report Line chart is full of data which aggregated as sum of all Id's.
But I want to show empty line chart when nothing is chosen in Table visual and show line chart when user selects one row from the Table
please, help :)
3 Replies
Hi az38,
When user opens the report Line chart is full of data which aggregated as sum of all Id's.
But I want to show empty line chart when nothing is chosen in Table visual and show line chart when user selects one row from the Table
For your requirement, If you want to achieve that it in the same page, I have no idea currently. I'm afraid that you should use the feature Drillthrough to achieve that.
You could create a table visual in Page1 and then create the line chart in Page 2 called Drillthrough like the image below.
In addition, you could refer to my attachment.
Best Regards,
Cherry
Hi az38,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
- Hi! I didn't solve this problem. Your solution is not the same what i exactly need. But thx for help, anyway :)
