The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I am new to this community and I am trying to adapt a custom visual to meet my needs.
The issue is that when I am trying to populate the custom visual with Measure data which are of type Text, Power BI Desktop does not let me keep the text (it forcefully aggregates/summarises it by either Count or Count Distinct). I even used a custom measure on the text data and it does not let me use it as a measure data.
But when I tried this in the Power BI service it let me enter the text column inside the measure (by aggregating it using First, Last which were not an option in PowerBI Desktop) and it also accepted the custom measure on the text column without any issues.
Does anyone know how I can adapt the custom visual to accept text data without forcefully aggregating it to integers and work in Power BI Desktop?
For more context, the custom visual I am adapting is KPI grid and I am using hierarchy data for grouping and a list of URLs as the text data.