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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
gzmtpck
New Member

visualization need

Hi, for my project i have celebrities and their instagram followers' count. In the report when i select a celebrity's name it must be show me that celebrity's followers count. But in my situation, the place that needs to show me number only shows me how many celebrities are there. İ want to show that a celebrity and his/her instagram followers count. Note: celebrity's name and followers count are in different visual part.

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @gzmtpck ,

 

According to your description, when you successfully import the data source. You can create a dimension table of celebrity as a filter, and then create a measure to count the number of different celebrities. I did a test, the reference is as follows:

vhenrykmstf_0-1630570822516.png

 

M_count =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[celebrity_id] )
)

 

vhenrykmstf_1-1630570886042.png


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
sarajampen12
Regular Visitor

In fact, popularity on social networks also has a downside. Influencers actually face negative aspects check more here such as criticism, negative comments, and public pressure. Of course, this has an impact on the mental state. For example, I like Matildem Marroni, who really became famous on social networks. I watched a lot of her publications and read her content. I believe that depression and stress can be serious issues for celebrities, and it is important to seek help and support if they are facing such difficulties. However, I am sure that she will be fine.

v-henryk-mstf
Community Support
Community Support

Hi @gzmtpck ,

 

According to your description, when you successfully import the data source. You can create a dimension table of celebrity as a filter, and then create a measure to count the number of different celebrities. I did a test, the reference is as follows:

vhenrykmstf_0-1630570822516.png

 

M_count =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[celebrity_id] )
)

 

vhenrykmstf_1-1630570886042.png


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Fowmy
Super User
Super User

@gzmtpck 

If you can share some data explaining your problem and the expected result it would be great to find a solution.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

AshwinKulkarni
Advocate I
Advocate I

Hi gzmtpck,

You can use Celebrity name in slicer and use card visual for count of Instagram followers.
Using card you can also show increase and decrease in count of followers.

Hope this will help!

Thanks and regards,
Ashwin Kulkarni

amitchandak
Super User
Super User

@gzmtpck , There is no standard connector for Instagram -Idea pending

https://ideas.powerbi.com/ideas/idea/?ideaid=8ab33cec-9e48-485b-9640-48b300bbe2cf

 

You need to use API or thrid part connector

https://bigintsolutions.com/free-power-bi-custom-data-connectors/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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