Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day:
Outstanding - the option to connect to the defualt view.
But
Text box data is still being desplayed as follows:
<div class="ExternalClass628AFAA1914A435A8618F3CAD921FA9C"><p>One of groceries <br></p></div>
I dont know of a way to transform this data correctly. Only the red should be visable.
On the Transform tab, you can use Extract Text Between Delimiters and use <p> and <br> as the delimiters
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for the suggestion but the output is diffrent for each eantry:
<div class="ExternalClassA2B2634292FD4A2EBE94997079B837EA">CLOVER ORANGE NECTAR JUICE -500ml<span id="ms-rterangecursor-start"></span><span id="ms-rterangecursor-end"></span></div>
<div class="ExternalClass57494869E3214A98962503ED16E40B3B">PNP CHICKEN STRIPS SALT<span id="ms-rterangecursor-start"></span><span id="ms-rterangecursor-end"></span> & PEPPER 250GR </div>