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.
Hello everybody!
In my report I have a line chart which shows values that are dependent on which category you choose in a filter. However the values are always shown in one format, based on the data type. Is there a way to format some values (dependent on which category you choose) as a time and others as decimal?
Data example:
ID | Employee | Date | Metric | Value |
1 | John | 01/01/2020 | SALES_VALUE | 1200 |
2 | Peter | 01/01/2020 | WORK_TIME | 01:37:00 |
3 | Peter | 01/01/2020 | SALES_PERCENT | 25% |
I expect to get a line graph, where the manager could choose one metric, and this metric would appear with the correct format.
Is there any way to do this without splitting into different columns and formatting each?
Thanks!
@Anonymous , When you change measures inside a measure then formatting is an issue. Unless you pre-format them. Bookmark can replace chart and allow you to do
For slicer way refer: https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
for bookmark refer : https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos.
If returning text is OK then you can use FORMAT.
Hello!
Well, I guess not, because the graph will also feature a daily average per metric. Is there some way to do math operations if returns text?
@Greg_Deckler Hello!
I've created a exemple project, can you take a look? There is a line graph with metric x time, and I filter it by metric.
https://drive.google.com/file/d/1IZRugbtavASNUdR-12XVrQjRix0sYJ2b/view?usp=sharing
Hi @Anonymous ,
It can't be achieved in one table to dynamic change data type based on slicer in one chart . You can refer to the similar post : https://community.powerbi.com/t5/Desktop/Need-to-change-symbol-format-based-on-slicer-selection/td-p/1030056
As a workaround, you should divided them into three tables and use bookmark to achieve your requirement.
Best Regards,
Dedmon Dai
Hi @v-deddai1-msft could you elaborate on that? Would I need to create 3 separated visuals?
Hi @Anonymous ,
Yes, you need to create three visuals for it. Please refer to the simliar post: https://community.powerbi.com/t5/Desktop/Dynamic-grouping-based-on-slider-selections/td-p/1003423
Best Regards,
Dedmon Dai
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |