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.
is there any way to implements visual like this?
if year is 2015 then blue
if year is 2016 then orange so on....
and i want to display measure values using bars.
Solved! Go to Solution.
We can use sparked bar instead of bar and achieve above result. USE below measure:
bar=if(hasonevalue(dim[column1].year),rept('|',count_id),blank())
count_id=count(fact[fact_id])
@Anonymous
This is the closest I've achieved:
Proud to be a Super User!
Paul on Linkedin.
this will work for single measure only.
If you have to add more than 2 3 measures you have to add it into tooltips and to see the measure values you need to hover over bars.
But, our client don't want this type user interface. they are expecting to have bars in matrix/table or any other visual where visualization for all values(measures) should be clear.
@PaulDBrown wrote:@Anonymous
This is the closest I've achieved:
We can use sparked bar instead of bar and achieve above result. USE below measure:
bar=if(hasonevalue(dim[column1].year),rept('|',count_id),blank())
count_id=count(fact[fact_id])
Hi,
You can format the colors of the bars by years through conditional formatting in the format of your bar chart under "Data Colors". As for the numbers, make sure you have Data Labels set to ON to display numbers for each bar.
If you have any other questions, I would be glad to help!
Thank you
I have 8 to 9 measures in my report. i want same colour for all measures for particular year.
e.g for 2017 year measure1, measure2....so on will be blue
for 2018 year measure1, measure2....so on will be orange.
can we add multiple measure in bar chart? i don't think so we can add. bar chart is not correct visual for above scenario.
if you are trying to do it in a pivot o matrix table, I don't know how to do it, I've tried it but I can't find the option, the only thing close to what you want, is to change the color background without distinguishing which number is greater than another.
create a calculate column with the colors you want, something like this.
I would be interested to know too,
regards
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |