Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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:
M_count =
CALCULATE (
COUNTROWS ( 'Table' ),
ALLEXCEPT ( 'Table', 'Table'[celebrity_id] )
)
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.
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.
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:
M_count =
CALCULATE (
COUNTROWS ( 'Table' ),
ALLEXCEPT ( 'Table', 'Table'[celebrity_id] )
)
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.
@gzmtpck
If you can share some data explaining your problem and the expected result it would be great to find a solution.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
@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/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
96 | |
69 | |
45 | |
39 | |
30 |
User | Count |
---|---|
159 | |
98 | |
60 | |
42 | |
42 |