visual option / measure filter

[Iculi]

Hi Dears,

I want to create one performance chart where i counted my partners who performe less and more. I have one measure (%) and i want to see how many partner have

less than 6.9% performance and what is there avg performance

between 7-19.9% performance and what is there avg performance

and greater than 20% ...

when i have a normal data in my table i use card visulaization where the fields is the partner count and i used visual filter w the recuested data, but when i tired to use here my measure data, this filter part went out inactive.

Do you have a idea how can i solve this issue?

Thanks,

Icu

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Iculi]

Hi,

Thank you for your answer. Here is my test file w this problem. I hope i created rightly for this file. 

https://drive.google.com/file/d/1u3IM885WGEGb7U9pFF0fFUUReG7GAsXz/view?usp=sharing

[lbendlin]

Please explain your data model. Can the Baseline and report tables be combined into a single table?

[Iculi]

Hi Ibendlin,

Yes, we can add these baseline info for the current report file but when i start this dashboard we had no this baseline part, it was comming later, and baseline is totally fix data, we have a same baseline every month, so i don't need refresh, but the current file need to refresh every month...

[lbendlin]

The only scenario where a 1:1 relationship makes sense is when you want to selectively load columns of a table.  It is not suitable for your scenario.