Forum Discussion

flare_11's avatar
flare_11
New Member
5 years ago
Solved

Hide responses in visual (100% stacked column chart) where respondents are less than 5

I am new to Power BI and am learning every single day. I have a data source that is currently in the form of a 100% stacked bar chart (survey). The responses are in the form of strongly agree, agree,...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi flare_11 ,

     

    Please try the following formula:

    Measure = 
var _percentage=DIVIDE(CALCULATE(COUNT('Table'[ID]),ALLEXCEPT('Table','Table'[Responses Type])),COUNTROWS(ALL('Table')))
return IF(COUNT('Table'[ID]) <5,0,_percentage)

    The final output is shown below:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hello flare_11 ,

 

can you maybe share how the tables in your data model look?

The description lets room for interpretation and that makes it harder to get to a solution.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
SAMBANU's avatar
SAMBANU
Regular Visitor
3 years ago
Hi, As mentioned by Flare is it possible to hide the coomplete graph when the threshold is less than 5. Currently the above solution hides only responses.