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 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.
@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/
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
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |