Forum Discussion
quickbi
Helper II
Helper IIError 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], ", " )
quickbiHelper II
Helper IIHi 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
AllisonKennedy
Community Champion
Community Championquickbi 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], ", " )