Forum Discussion
Text Box Dynamic Values are hidden when when previous value is blank
HI ADrumheller,
In fact, I test both October and November versions[Version: 2.99.782.0 64-bit November 2021] power bi desktop with two report files(dummy data and your sample) but both of them work without the value change issues. If you are working with a different version, please try to update to the latest version to confirm if this issue is fixed.
>>Looking at the review order if in this example "3526 Tech" was blank then "3526 Case" and "3526 Issue" would not show anything either.
I also check the smart narrative queries and find both of them include the filter on the '3526' item. If some filter effect excludes the '3526' item, all the queries which include the same item filter will show the blank because no matched item is left to do the calculations.
Query:
#1, sample table technician By 3526(Machine)
#2, max Sample Table total downtime by 3526 (machine)
Comment:
#1, sample table technician (analysis target field) By(filter keyword) 3526(filter value) Machine(filter target field)
#2, max (calculate max) Sample Table total downtime (analysis target field) by(filter value) 3526(filter value) Machine(filter target field)
Regsards,
Xiaoxin Sheng
In the sample data i sent 3526 is fine, the fault starts to occur after 3559. 3559 is missing data and has nothing show (as i would expect can show what isnt there), but 3560 and 3561 both have there info and are showing blank. below is what i see looking at the sample data. I am using the latest version (had to update for desktop exporting bug).