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.
i have column named DOWN_LINE_TYPE_VALUES it only have the vlaues (0,1,2)
when i added it to the map it shows vaules like 22,18 ,4 ,etc
i don't under staned where these values came from i only want (0,1,2) to be shown
so how can i make it to only shows the real values (0,1,2)
Solved! Go to Solution.
Hello, @Aref
According to your description, I created data to reproduce your scenario. The pbix file is attached at the end.
Mesa:
You can create a measure as follows.
Value Measure =
CONCATENATEX(
'Table',
'Table'[Value],
","
)
Finally, you must place the measure in the 'ToolTip' to display the result.
Best regards
Allan
If this post helps,then consider Accepting it as the solution to help other members find it more quickly.
Hello, @Aref
According to your description, I created data to reproduce your scenario. The pbix file is attached at the end.
Mesa:
You can create a measure as follows.
Value Measure =
CONCATENATEX(
'Table',
'Table'[Value],
","
)
Finally, you must place the measure in the 'ToolTip' to display the result.
Best regards
Allan
If this post helps,then consider Accepting it as the solution to help other members find it more quickly.
@Anonymous , If there are more than one rows it will aggregate the data. As of now, it counts on tooltip.
@Anonymous apart from all other genius replied to your question, you need to understand the basics of the Power BI. I would recommend looking at a self-guided learning course available on Microsoft. it will take you a long way rather than just finding an answer to one of your questions, although you are welcome to ask as many as you want. Just my 2cent.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous - Looks like there are multiple rows of data and it is doing a count aggregation. Is that true?
yes, so how can i solve this issue?
so how can i change the aggregation mode, i'm clueless ?
@Anonymous ,
Click on the column name inside the ToolTip box and change the aggregation.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates
It also applies for desktop.
non of them shows the real values (1,2,0)
@Anonymous it has to be an aggregation, you cannot use column value on the tooltip, you can change first or last value but it is still an aggregation. Just want to be very clear here.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
111 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |