Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
Hi Anyone know if I can visualize as the below in power bi?
I have ranking measurement(dynamic) and some KPIs and also Dimensions.
I want to show top 1 ~ 20 articles with Image and some related KPIs and dimensions as the above.
Could I get your support?
I have used Card Browsers but it I can not bring needed KPI to the front image...
So I want something like the above.
Thanks
@JIN23 there are a few ways to add images to tables in Power BI - the way I typically use is to store a link to the image (this can be SharePoint or a public link URL) in the data model, then add this as a column to the table.
Display images in a table, matrix, or slicer in a report - Power BI | Microsoft Learn
Depending on how you want the layout with the 20 different items and images you may need to play around with the data and table formatting to get something close to what you're looking for.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi Thanks for the support, I want exactly the same display that I have put as example. I have image URL which I can put into tables but the thing it layout of table is not what I wanted in the provided visuals in the BI.
If you know if I have make the tables that I have explain the above, please kindly support me
You'll need to change the layout slightly to use the default core visuals - you can have the Image in the column on the right, with Rank as the heading:
Rank 1 |
|
div | xx |
product | xx |
Season | xx |
etc | xx |
etc | xx |
My original question was around how you want to specify that you're viewing Rank 1 rather than Rank 20, as if I understand your question, you want to have this work for 1 through 20 ranks? Do you have a slicer to select the rank ? or do you want to see all ranks at the same time?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Oh I see. I want to show 5 rankings per line.
The thing is that I am using ranking with dynamic ranking measurement, which I can not put it to row or columns but only values.... that is the difficulties that I am having now
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |