Forum Discussion
Solved
Error SelectedValue
Hi All, I'm making a P&L statement and I'm using a PL mapping section: When I create a Pivot in PBI I assign the fields as: Where selectedvaluetest show for each row what row is cal...
quickbi ok, my next hypothesis is that there are some null or blank values getting in the way. Can you try changing your selectedvalue test to use
CONCATENATEX( VALUES(tablename[Level1]), tablename[Level1], ", " )
Hi AllisonKennedy
thanks for your answer but is not the problem because all level1 are showing if they are or aren't collapsed.
...and I expanded all Margin level but did not show anyvalue
quickbi ok, my next hypothesis is that there are some null or blank values getting in the way. Can you try changing your selectedvalue test to use
CONCATENATEX( VALUES(tablename[Level1]), tablename[Level1], ", " )