Forum Discussion
Text Box Dynamic Values are hidden when when previous value is blank
HI ADrumheller,
I tried to change the filter to let the smart narrative variable show blank at first, these dynamic values work and do not reproduce the issue after I change filters. What version of power bi desktop are you testing?
Can you please share a pbix with some dummy data? It should help us clarify your scenario and test to troubleshoot.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hello,
I am using the current version (November 2021). Hopefully you can view this Sample Data, this is the 1st time posting so wasnt sure of the best way to share the file (if this way even works). If you can see the file you can see that in the top right there is a slicer for shifts selecting Day or Grave shows all the data, but when selecting Swing 3559 3560 3561 have no data populating. looking at the table and filtering there is no data from 3559 but there is for 3560 and 3561. So it would seem like because 3559 is missing anything past (in the review dynamic values) wont populate. Thank you for all the help.
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).