The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I want to make this line chart where the source of values highlited in yellow are from excel file and the value in the red cercle comes from a measure :
Is it possible ? if yes how do i must connect the excel file to the date table
Thank you
Solved! Go to Solution.
Hi @Mannai ,
Yes,you could .
Create a relationship between two tables based on date association if the data is not on one table. If on a table, create visuals directly.
Refer the below:
values is measure:
Outputresult:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @Mannai ,
Yes,you could .
Create a relationship between two tables based on date association if the data is not on one table. If on a table, create visuals directly.
Refer the below:
values is measure:
Outputresult:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
@Mannai , for that you need to have a column that gives Qtr + month Feb. Then you add those measures and show
Or create a custom table and then use it( append two data )
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
183 | |
80 | |
62 | |
46 | |
38 |