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.
Hi, what I want to do is to create a report which shows the text value from excel file. Can anyone help me to achieve the idea?
for example, I would like to create a similar format to this excel worksheet in power bi, which can show the text result of each category. Is there any method that we can use Card function to show the text?
Thanks so much!
As stated, it is not a good idea to have merged cells. Power BI will place the value in the first cell of the merged cells.
For this worksheet, you could do the following steps:
Here, this will give you a format compatible with Power BI, and a line for each combination. This will allow you to construct a report that can display text from a card, or simply put all in a table.
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Not sure if I understand, but if you to see the same structure as in Excel you add a table and select all columns that you want. Then you can add a slicer if you just want to see one category. I think we need to see more of the table structure and the expected outcome.
Thanks so much for your reply. The image is from excel report. All the values or texts in the yellow area will change after I change parameters in another worksheet. I would like to have a similar report in PowerBI with Card Function, so that I can modify the shapes and sizes of boxes, and rearrange them to have the same format as this excel report. For now, I do not know how to link the card function with individual excel cell. For example, I want to make a card link to and show the value in cell D3, "Energy Consumed (e)", could you please teach me how I can achieve this result?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |