Hello
I am just starting to work with Power BI, and as I expected I have my first problem, where I hope to find a solution here 🙂
I have a table with the following fields:
Status
Year
Sales
I created a stacked bar chart and a textfield which shows the value of the selected bar.
For example:
Status = Awarded
Year = 2017
Sales will change to the respective amount.
What I would like to have is something like
Awarded in 2017 is xxx US $ - so in short I want to add the fields.
Any idea how to achieve it in an easy way?
Thanks
Cool My dear friend,
Try this,
let me know if any help on this
Thats not what I meant
I want to add the following
Awarded for 2017 is US $ xyz
- The word awarded has to be changed based on the selected status
- The year has to be changed on the selected year
- The sales has to be changed
So far only the sales changes, which is the standard functionality of BI.
You can create the following measure and put it in a card visual that changes based on your selection
Text= VALUES(Table1[Status])&" for year "&VALUES(Table1[Year])&" is US $"&VALUES(Table1[Sales])
Make sure to have your Status and Year columns put in a slicer.
Hope this helps.
I managed to do something similar by creating a Measure with the text/data I wanted. The measure name is 'Title'
Title =
"Data For "
& MAX( V_DailyTransactions[AsOfDate])
And then I placed this measure in a Card visualization.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
75 | |
65 | |
56 | |
55 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |