Forum Discussion
mbudiman
Helper III
Helper IIIHide Measure column in Matrix that contains no value
hello, I have 2 tables, Fiscal_Qtr table and Sales Forecast table. Fiscal_Qtr table contains custom financial quarter period, where a field called Qtr_Sequence_No is used to define sequence of Quart...
You forgot to either expand or go into the next level in the hierarchy. If there isn't a single field of the display column parameter, SELECTEDVALUE returns blank so none in the switch conditions is met.
mbudimanHelper III
Helper IIIhi Danextian,
The solution works 🙂
So I try to recreate new table matrix according to your advise :
1. Use the Field parameter as column header and set "Show Selected field"
2. I use the measure you had already created.
However, no value is display in the matrix. Do I miss any step ? Could you help me one more time to point out missing step. I've upload the pbix. The new matrix I created is in the "Test" tab. Thank you in advance for your help.
