Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
eilshga
Regular Visitor

Data categorization for measure

Hi All,

 

I understand that we can't categorize the Data for a Measure.

 

I have a huge file of 10000 Datapoints where I have the info about Project details, status, savings, Project lead emails etc. Now i have created a Table with dashboard slicers for End user about the type of Projects, Project Status, Progress Level and much More. There is also a column with project lead email (hyper link to create AUto email to Project Lead)

 

Now end users want to see a project list with all Projects running behind the Plan, they can see it by appropriate selection of slicer and if they want to contact Project lead, can do so by cliking on Project Lead email hyperlink...

However, There could be 400-500 such projects and contact to each via such way is next to impossible. So looking for a option to have a common link with which email can be send to all leads in 1 go.

 

I am able to create a measure with concatenate of Data and adding "mailto:" in the start. However, not able to convert the Data categorization to web URL as no option for same in Power BI.

 

Could there be any other option with which I can get it done?

 

1 REPLY 1
v-yulgu-msft
Employee
Employee

Hi @eilshga,

 

As you said, we are not able to set the data categorization for a measure. Why don't you create a calculated column with concatenate of Data and adding "mailto:" in the start so that you can set its categorization to Web URL? 

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.