Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am using a DirectQuery to pull data onto a table on the report
tblPCodes
----------
pCode perf
xyz 123
gft 67.9
twu 55.31
...
I created banding i.e. range of values to workout he count of pCodes that fall within bands... the measure which does the count of pCodes is called count
This is good so far.
The chart I have created shows the count on y axis and the band on the x axis
All good so far...
Now, I would like to be able to click on the bars in the chart and so the data inside the tblPCodes visual to filter for only those pCodes in that Band. But it does not filter the tblPCodes.
Probably it is to do with the DirectQuery....
In-case it is helpful, the measure that I am using to get the count of the pCodes in tblPCodes is:
count =
COUNTAX(
FILTER(
'Unitised Performance',
[Performance] > SELECTEDVALUE(PerformanceBands[Low]) && [Performance] <= SELECTEDVALUE(PerformanceBands[High])
),
'Unitised Performance'[Portfolio Key]
)
How can I achieve this please?
Thank you
Hi , @Anonymous
Not very clear. Can you explain bit more?
Sample data and expected result will make it easier for us to understand and solve your problem.
Best Regards,
Community Support Team _ Eason
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |