Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am new for Power bi.
I have a filer mechanism: service
service
the data on the table will be displayed based on the Service filter value selected
example if "IT" is selected the power bi displays
Service | Section | Title |
IT | Computer | computer training.. |
IT | Software | Software application |
IT | Database | sql server database... |
Service column is repeating , so I want to avoid it, instead , i want to show it above the table:
Service:IT
Section | Title |
Computer | computer training.. |
Software | Software application |
Database | sql server database... |
How can I display that?
my second question: I want to show checkmark box in the service list, how can i do that?
Hi, @IloveTigray
Thanks for your sample data first!
According to your description, you want to avoid repeating column value and show only one single value of it.
Here are the steps you can refer to :
(1)This is my test data:
(2)We can close the "text wrap" for the table visual:
Then we can drag our mouse to display the column we do not want to show:
(3)If we want to show what you have selected you can create a measure and put it on the card visual:
Measure =
var _selected = VALUES('Table'[Service])
return
"Service" & ":"&CONCATENATEX(_selected,[Service],",")
The result is as follows:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |