Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
It seems a problem with HTMLViewer, cannot clear data of the previous filter.
Solved! Go to Solution.
Hi @tanquoc0309,
I didn't encounter this problem on my side. Please remove the HTMLViewer and re-add it to desktop for a test. Please check if this sample .pbix file contains HTMLViewer works on your side. Besides, if possible, please update your desktop version to the latest one for a test.
Regards,
Yuliana Gu
This issue is 100% reproducible IF you have rows in your dataset that are empty/null. To repro:
1. Add HTMLViewer to the canvas & configure it to use an appropriate column in your dataset
2. Add a filter control so you can quickly jump between rows
3. Using the filter, select a row that contains HTML data. the HTMLViewer control will show it
4. Now select a row that contains no HTML data.
Result: the HTML viewer will continue to show the data from the previous record.
Expected: the HTML viewer should clear
My workaround is to use Power Query to create a new column, replacing null values with a single space:
= Table.AddColumn(#"Removed Columns3", "Scheduled Next Week1", each if [Scheduled Next Week] = null then " " else [Scheduled Next Week])
Microsoft: please work with Hitachi to fix this bug.
Hi @tanquoc0309,
I didn't encounter this problem on my side. Please remove the HTMLViewer and re-add it to desktop for a test. Please check if this sample .pbix file contains HTMLViewer works on your side. Besides, if possible, please update your desktop version to the latest one for a test.
Regards,
Yuliana Gu
| User | Count |
|---|---|
| 54 | |
| 37 | |
| 27 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 38 | |
| 21 | |
| 21 |