I have a heatmap that I created in PowerBI. When I have my lot data on my y axis, it cuts off at lot 508. However, when I display it on my x axis I can see all my lot numbers. Does any one have an idea of why this may be? I have two dynamic axis which are using feild parameters. The filters are also filtering each other so that if you make one selection, that selection will not show on the other filter.
Hide = VAR SelectedAttribute = [First selection]
VAR SelectedAttribute2 = [Second selection]
Return if (SelectedAttribute = SelectedAttribute2 , "Hide")
Also, I had to unpivot the data I wanted to use as a filter on the x and y axis.