Forum Discussion
Strange Legend Error
The strangest thing is that I have recreated the visual in a new report (copying and pasting all the query steps to make sure it is essentially the same data) and the visual works perfectly there! So it's definitely not the data but almost like something is broken in that specific Power BI report file itself.
Hi Anonymous
It may be that there is an "other" category with some data or calculated bands not being handled correctly. Might want to check the calculation by copying the legend to a matrix visual and seeing it there is a new category that is not Low , Medium or High. It may be that the <= , > logic has created a gap somewhere and didn't show up before with previous data.
I had this problem before and a check on the measures logic helped.
If you need help debgging the logic, maybe post that and I can give it a look over
Cheers
Manfred
mwimberger This is what it looks like in a matrix:
Hi Anonymous does your measure to assign bands have multiple "Low" and "Medium" Bands?
Here is something that I use to assign bandings.
Overall Impact Summary = switch(true(), [IMPACT]>=0 && [IMPACT< 0.25 ,"Low"", [IMPACT]>=0.25 && [IMPACT]< 0.5 ,"Medium"", [IMPACT]>=0.5 && [IMPACT]< 1 ,"High"", "Error")
If you need a table with upper and lower limits for bands I can give that example too.
Limit Band= CALCULATE ( VALUES ( tblBand[Band] ), FILTER ( tblBand, [IMPACT] >tblBand[Lower Value] && [IMPACT]<= tblBand,[Upper Value] ) )Where the tblBand may be something like this:
Band Lower Value Upper Value Low 0 0.25 Medium 0.25 0.5 High 0.5 1