Forum Discussion
Helper IIICreate Table
Hello,
Thank you very much for the help provided.
I solved my problem using the HTML visual.
Community ChampionMathieuF Maybe use a Matrix visual and the "Show values on rows" functionality under I think the Values format card.
Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Helper IIIMy file is too big and complicated to share.
I put a "Matrix" visual but why don't I have the columns that I indicated in the configuration.
Here's an example I made quickly. https://drive.google.com/file/d/1rIQ_DQlX4stm936jYJABbAXi27cpGkvm/view?usp=share_link
- Greg_Deckler
MathieuF So given the sample data provided, what are you desiring to see in the visual? I'm not quite understanding what you want to see in terms of the actual numbers.
- MathieuF
I would like to have 3 columns, Agent, Team, Skill
- Greg_Deckler
MathieuF I understand that. But, what are the actual numbers that you want to appear in those columns? Is the Skill for Jack in Group C going to show the number for Jack with Skill XAX or is the Skill column supposed to show the average for the KPI for Jack and Paul in Jack's "row" and Paul's "row"? Or something else entirely?