Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi! I am trying to create Custom column to recognize rich text in this way and I am having issue. Can anyoneyou help me to solve this issue here. Later I need to use this column in the matrix. Thanks
Solved! Go to Solution.
Simply add a custom column in Power Query :
Html.Table([Column1], {{"ExtractedText",":root"}})
The HTML.Table function you are trying to use does not exist in DAX. Power BI does not have built-in DAX functions to parse or handle HTML content.
Can you provide the expected result so we can help you ?
I have a column in the table this way below
I need to show this column in the matrix instead of cleaning HTML tags I am trying to translate as Rich text. Is there anyway to translate the column . Any suggestions. Thanks!
Simply add a custom column in Power Query :
Html.Table([Column1], {{"ExtractedText",":root"}})
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
71 | |
56 | |
39 | |
35 |
User | Count |
---|---|
66 | |
66 | |
59 | |
53 | |
45 |