The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone,
I'm embedding a Power BI report in Java Web Application. Date values are selected on an external filter by the end user and is passed to the Power BI report as a report level filter using the Javascript API.
I want to display the selected date range values on my report . But the problem with MIN and MAX is that the Dates in the external filter will be a greater range than that of in the dataset .
Eg . filter maybe selected from 1/1/2018 to 31/12/2018 ,but dataset may only contain dates from 1/3/2018 to 1/10/2018.
So the date range shown on the report will be different from that of the selected values.
Is there anyway for Power BI to read the values passed to it through the API ?
@Anonymous,
You may try applying filters to a calendar table in the dataset.
User | Count |
---|---|
85 | |
84 | |
36 | |
34 | |
32 |
User | Count |
---|---|
93 | |
79 | |
66 | |
55 | |
52 |