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 all,
I'm trying to add a sparkline to my matrix which shows the dynamics from month to month.
The problem is the columns in my matrix are also months which makes Power BI add a sigle dot to them.
Any idea if there is a possibility to only keep the sparkline for the total (remove these two "Gap" columns in red rectangles)?
Thanks!
Solved! Go to Solution.
Hi @itskool ,
Just narrow the width.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @itskool ,
Just narrow the width.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Interesting workaround.
But it would be nice to have something to handle this more nicely.
For example, I want to achieve the following (examples using financials sample dataset).
It is a different workaround where I overlay the matrix without sparkline on top of the matrix with sparkline.
Best I can do with one table at the moment is the following.
I do not want to display the Total column.
I also wanted to hide the label for the values and it ended up cutting off the "Product" in the header.
I hope to see the feature in the "Format visual" tab to customize this sparkline visual.
ok, that should be fine for a workaround, thank you!
Hi @itskool ,
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Henry,
Thanks for the reply.
It is not really clear to me from the screenshot - how did you make the lines disappear?
@itskool , even if you use all or time intelligence you will only get one consolidated value. I doubt this
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |