Create new values/measure to filter on visuals

[Anonymous]

Hello everyone, 

I created survey and want to display the outcome by a PowerBI visual (infographic designer). The visual displays all departments of a company. It look like a house and the departments are boxes, which turn green, yellow or red. The colour depends on values between 0 and 1 from the survey data. 

I want to have another kind of filter, which exclude departments if they do not reach a minimum number of participants. The best would be if the boxes turn grey to visualize that they are excluded. 

Because I am new to PowerBI I need your help. In Excel I would use a IF-Formular and condtional Format. But I have to visualize it in PowerBI. 

So far I tryed to create new tables and a distinct_count on the specific departments, but PowerBI only referes to columns and not to cells. 

I am thankful for all your help. 

[amitchandak]

@Anonymous , you need to create a dynamic bucket for that.

refer

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/

[Pragati11]

Hi @Anonymous ,

Not able to understand you issue. Provide details please.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati